SQLExpresss losing connection to VB6 application

I have a VB6 application that has MSDE as its current backend. In testing moving to SLSQLExpress I've noticed, since this application is run on laptops, that if I disconnect a connected network cable while I'm in the VB6 app I lose "connection" to the local database. If I end task on the app and restart it it works fine. If I reconnect the network cable while the app is running and then disconnect it the app runs fine. Also this happens when I'm connected to a wireless network and then disconnect and disable that connection.

In my template.ini file I have DISABLENETWORKPROTOCOLS=0. Is there a setting I'm missing? I can't seem to find anything else to set in the ini file.
Who is Participating?
jeepstyx22Connect With a Mentor Commented:
If you are using TCP/IP then when you get disconnected from the network, bound protocols are dropped.  In the case of sql, port 1433, which would cause sql to disconnect.  
See http://support.microsoft.com/default.aspx?scid=kb;en-us;239924

Other option would be make sure that you are using localhost, or as the host. see http://www.adras.com/Network-error.t17343-18.html
KOCUBAAuthor Commented:

Thanks for the response. The info in the first link worked great in real world, but not in VMWare. Not sure why but don't care.  Actaully am going the route of adding "server= localhost" to the connection string feel that it is safer and I don't have to worry about our support staff going into the registry when it is unnessecary.

Again thanks for the great answer(s).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.