How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?
Database connectivity, IIS, Oracle 10g, Oracle 9i, VB, Visual Basic, Visual Basic 6, w3wp.exe, Windows Server 2003
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
Software/Hardware used:
Software/Hardware used:
ASKED:
August 22, 2008 9:47 AM
UPDATED:
September 28, 2008 6:10 AM
RELATED QUESTIONS
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
