SQL Error Msg 10040

I'm trying to connect to an SQL server, but keep getting the following message
"Db-Library network communications layer not loaded"
Does this mean that the server is not responding (i.e. not there)?, and how do I fix it?

Thanks,
Paul
bickieAsked:
Who is Participating?
 
cymbolicConnect With a Mentor Commented:
As a basic test of your connectivity, try first to map to a drive/volume on your server.  Also, sometimes mapping a drive first facilitates your connection to the server.  If this doesn't work (and I suspect it won't) chances are good that a necessary network protocol is not loaded.  Load these in the network icon inside of your control panel inside the My computer icon on your desktop.  Sounds like those little Russian eggs, one inside the other, doesn't it!
0
 
cmcnallyCommented:
Hi Paul,

There could be a number of reasons for that error, I would recommend trying the following steps.

What protocol is the MS SQL server set up to use? Named Pipes?, SPX?  If so, use Control-Panel, Networks and make sure you have TCP/Ip or SPX installed, and Client for Microsoft networks if you use TCP/IP or Named Pipes.

Have you installed the client utilities for Microsoft SQL server from the Microsoft SQL server CD?  If not, you must install client drivers and choose the 16 bit client or 32 bit client.  When installing the client, you will be asked which 'network support' to install, named pipes, tcp/ip, ipx etc.  The server will be listening on one or more of those protocols.

Reboot.  The installation may add to your Path statement

Find out which prototcol the server is listening to.  Then run the 'sql server configuration utility' on the client.  This utility lets you choose the network protocol to use and will search your 'path' for the proper DLL's to connect to the server.  If the utility cannot find the DLL's then your path may be too long with the addition of the new path to the dll's.  

#3 if you are still having problems
0
 
bickieAuthor Commented:
Thanks,

I've got it too work now!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.