Solved

SQL Error Msg 10040

Posted on 1998-01-14
3
1,229 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

696 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