Connection Timeout

[Memento]

Windows 2003
Sql Server 2000
Tablets with Windows XP Tablet Edition

We have a wireless network with an application that runs off of SQl Server 2000. Periodically, the tablets we have loose conncetion from the network. If they are in the application while their connection goes down and a little while later comes back up, the following error message is spammed:

Database error code 999
Select error: SQL State=08S01
Microsoft ODBC SQL Driver Communication Link Failure

They can't save their work or reconnect to the database once they get this message. They have to exit out and go back in.

Any ideas on what might I can do to restore the connection once the network comes back up? The application is written in Powerbuilder. I'm really not looking for a Powerbuilder solution.

I'm thinking there's a ConncetionTimeout setting or possible a release on SQL Servers end that could work. Any ideas?

 

[mrdenny]

Unfornitually you need to put autoconnect logic back into the powerbuilder application so that if it sees that the connection dropped the application reconnects before attempting to execute the script.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com