Solved

SQL Error Msg 10040

Posted on 1998-01-14
3
1,205 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:bickie
3 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 50 total points
ID: 1089958
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
 

Expert Comment

by:cmcnally
ID: 1089959
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
 

Author Comment

by:bickie
ID: 1089960
Thanks,

I've got it too work now!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
export sql results to csv 6 35
sql server computed columns 11 31
Help creating a spatial object in SQL Server 4 22
What's wrong with this T-SQL Foreign Key? 7 44
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

770 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