• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

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.
0
KOCUBA
Asked:
KOCUBA
1 Solution
 
jeepstyx22Commented:
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 127.0.0.1 as the host. see http://www.adras.com/Network-error.t17343-18.html
0
 
KOCUBAAuthor Commented:
Jeepstyx22,

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).
Dave
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now