ODBC connection drop

D

Dunmarie

I am using Access 2003 to connect via ODBC to our MSSQL server.
Nothing wrong with the connection accept it drops after about 8 to 10 minutes.
We have set the ODBC refresh interval to 360 seconds and less without fixing
the problem.
We have done some axtensive testing of the network and could not find any
problems either.
Is there a time out / keep-alive on SQL that needs to be set?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top