CODEWITHSUNDEEP
odbclotus-noteslotus-dominolotusscript
Mike Jackson
Mike Jackson

Reputation: 427

Problem with IBM Notes ODBC Connections not clearing out on Domino 9 server

I support an older Lotus Notes application that uses ODBC to connect to Oracle for reading and writing purposes. Each of the connection objects are being set to Nothing when their routine is complete, but, for some reason, Domino will not drop the connections. This causes us to have to reboot the Domino server that application resides on every day. Sometimes, once a day is not enough to keep the program from grinding to a near standstill. Does anyone have any ideas how to get those connections to drop when the script is done processing?

MJ

Upvotes: 0

Views: 310

Answers (1)

Mike Jackson
Mike Jackson

Reputation: 427

It turns out that the ODBC class has a disconnect method. Who knew? Sorry to waste everyones's time. I put in the disconnect and problem was solved. Not sure why I never noticed it before. Anyway, thanks for the replies.

MJ

Upvotes: 1

Related Questions