Re: DB Disconnect/Reconnect

In article <8aqres$kab$1@nnrp1.deja.com>, jwz1@my-deja.com wrote: > I have a VB app that uses DAO and ODBC to connect to an Informix DB on > a SCO-UNIX server. The initial connection takes approximately 15 > seconds. Once connected, the response is adequate. However, if a user > has the app running, but doesn't use the VB app for some number of > minutes, maybe 10 to 15, and then performs an operation that requires > data from the DB, the app is very slow to retrieve the data. It seems > to be reconnecting to the Informix DB, again. Once this first data is > retrieved, subsequent reads to the DB are fast. > > Is the app disconnecting from the DB after a period of inactivity? Is > there a parameter that I can set to eliminate this disconnection? Has > anybody seen and fixed this problem? > > Thanks for the help. > > Joel > > Sent via Deja.com http://www.deja.com/ > Before you buy. > The connect time to the database might be a problem with the way that you are finding the server. Are you going through a DNS server to find the IP? Are you having any other similar problems using telnet or ftp? The disconnect would be something in the ODBC driver, most likely. Check the documentation for that. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

*If U use VB6, try to switch to ADO + OLEDB. Connection should not take that long, and the disconnection might cause by closing our connection inside the application. *Try to Declare and connect to the DB on a global level in your App, and close it only when the app is closed. *Try to use only one connection to the DB *Don't Attach tables ! Good Luck.