Solved

SQL Error Msg 10040

Posted on 1998-01-14
3
1,186 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

708 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

11 Experts available now in Live!

Get 1:1 Help Now