How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

5 pts.
Tags:
Database connectivity
IIS
Microsoft Windows Server 2003
Oracle 10g
Oracle 9i
VB
Visual Basic
Visual Basic 6
The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade to .NET due to limited resource. Replacing the DB call with a Java component or service may be an option, but not sure how feasible this would be. The component is set to stay active in memory, and I think this is what causes w3wp.exe to hold onto DB connections (although they do go to inactive). I need a way of having the connections dropped as soon as the transaction is finished - user logs out. We've already looked at changing connection pools and other minor tweaks on the server, not much success. Any useful suggestions would be greatly appreciated. Thanks A

Answer Wiki

Thanks. We'll let you know when a new response is added.

In your code you need to close the connection, and set the connection to nothing. This should cause the database connection to close and the connection to drop.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following