waiman
asked on
SQL Server "Communication Link Failure" problem
I have an application written using VB 4 and connected to SQL server 6.5 SP4 through RDO 2.0. (and ODBC 3.0). The application is running OK except if I leave the application on and do nothing around 20 minutes and then back on again (for example, press a button to retrieve data) an ODBC SQL driver error "Communication link failure" appear on the screen and I could not get any data. I looked for the query timeout factor within the registry under ODBC but the timeout value is already quite generous..
Can someone give me a clue what's happening, please?
Can someone give me a clue what's happening, please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Exactly that is the parameter. If you want to diasable it at all enter -1.
Else give the amount in minutes after that the server should
close idle connections.
Else give the amount in minutes after that the server should
close idle connections.
ASKER
I'll try that out first and I'll return to you later. I'm going to be on holiday this month so I would hold this for a while but I'll let you guys know the progress next month then I will rate the answers. Thanks a lot.
ASKER