SQL Server "Communication Link Failure" problem
Posted on 1998-10-06
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?