
VB ODBC <--> RDB Connection Issues
I am on a project where we are accessing enterprise data that resides on a VAX
rdb with VB through ODBC. We are having a problem with the server processes
eating up CPU time. This is unacceptable because the database is used for
other critical applications. The trouble is, we cant figure out what is
causing our process to take up so much CPU. When a connection is made, the
process runs normally, but as time goes by it demands more and more processing
time. It seems as though we are not closing threads in the processes, but
VB's close method doesnt seem to do anything, and VB claims that it cleans up
open connections when you exit the app.
Any suggestions or opinions would be greatly apreciated.