No connection to local SQL Server when no network connection

No connection to local SQL Server when no network connection

Post by peshra » Tue, 28 Sep 2004 23:34:25


Hi !

We are using Windows XP,
ADO.NET in our application (programming language: C#),
MS SQL Server 2000.
The computer is a SONY notebook.

SQL server is running on the same machine as the application.
The application has worked in many, many cases under W2K and even XP.
But on that computer it doesn't work:

When there is no network connection,
then the application CANNOT connect to our DB.
On the other hand, Enterprise Manager CAN connect.
When we plug in the network and restart the computer,
then the application CAN connect.
However, SQL Server is running locally !

The connection string for connecting our app to the database is something
like:

sqlConnection.ConnectionString =
"packet size=4096;user id=BIS;persist security info=false;initial
catalog=BIS; server=(local)";

How can we fix that problem ?
Your kind help would be appreciated.

Peter
 
 
 

No connection to local SQL Server when no network connection

Post by GTR_Legen » Sat, 02 Oct 2004 07:53:46

Have you tried removing the packet size=4096 in the
connection string, give it a go
application.
and even XP.
database is something
info=false;initial

 
 
 

No connection to local SQL Server when no network connection

Post by lemuppe » Fri, 08 Oct 2004 20:56:48


I have had similar issues - am not sure why though.

However,I seem to be able to connect by either using the (local) or th
actual PC name - it just seems to change its behaviour depending on th
network connectivity status.

Hope this is of some help.

LeMuppe


-
lemuppe
-----------------------------------------------------------------------
Posted via http://www.yqcomputer.com/
-----------------------------------------------------------------------
View this thread: http://www.yqcomputer.com/