Link to home
Start Free TrialLog in
Avatar of KOCUBA
KOCUBA

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of jeepstyx22
jeepstyx22

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KOCUBA
KOCUBA

ASKER

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