Solved

SQLExpresss losing connection to VB6 application

Posted on 2007-04-03
2
242 Views
Last Modified: 2010-03-19
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
Comment
Question by:KOCUBA
2 Comments
 
LVL 7

Accepted Solution

by:
jeepstyx22 earned 500 total points
ID: 18847416
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
 

Author Comment

by:KOCUBA
ID: 18851332
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now