Database Connection failure on MSDE Stanalone installation

[shridhargune]

Scenario –
On a standalone installation i.e client and SQL server are on same machine, if network connection is lost while preparing SQL server connection then SQL connection could not be established. This was detected only on few machines. The configuration details are:
OS : Windows 2000 SP 4 with MSDE
Error : MSVC exception occurred. This is not consistent. Some times it throws error in sql server connectivity DLLs.

 

[NoCoolHandle]

This is more likley than not somethign you can fix via a connection string attrib.

(post yours and it might be easier to find - but remove or change the part(s) that specifies passwords or other stuff you don't want to share)

In w2k if you dont have a network connection (because it isn't plugged in you can't get a named pipe..)

ie you can't even map a drive.

Rob