Solved

SQL 2005 Error - Connecting Excel workbook to SQL 2005 server

Posted on 2010-09-17
5
450 Views
Last Modified: 2012-05-10
I am trying to connect an Excel workbook to a remote SQL server database and getting the following error below (see code snippet). Any insight would be appreciated. Wondering if there is an easier method to connecting then what I have. I have VBA coding in the Excel workbook (if needed, I can provide it).
Connection failed:
SQLState: '01000'
SQL Server Error: 10054
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv()).
Connection failed:
SQLState: '08501'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

Open in new window

0
Comment
Question by:Jeff S
  • 3
5 Comments
 
LVL 6

Accepted Solution

by:
Metallimirk earned 250 total points
ID: 33706411
Error # 08501 is a communication link failure. This is a mid-stream failure of the connection from your application client (Excel) to the SQL Server.  This typically points to problems with your networking layer, possibly even your network hardware.  For example a router in your network could be dropping connections, or a network card that is going bad, possibly you need to be on your VPN if outside of the office, or ensure your connectivity to the Wifi Network is valid (if your not plugged in).

Unfortunately there is no simple and easy to follow way to diagnose this, it typically requires someone who is expert in network layer to analyze network sniffs between client and server. It would help us out a great deal if you provide us with more information regarding your network environment.
0
 
LVL 19

Assisted Solution

by:Bhavesh Shah
Bhavesh Shah earned 250 total points
ID: 33707055
10054 Connection reset by peer. [NT only]
This can happen if a sockets client (which includes SPX) is actively sending or receiving data to or from SQL Server, and the network connection is lost. This error is usually seen in conjunction with error 17824 when on sockets-based connections. For example, an Microsoft Windows NT client using the NWLink SPX transport could be selecting data from SQL Server, and if the network cable is unplugged from the SQL Server computer, you will see error 10054.
0
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 33707060
0
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 33816679
Hi....

Does your issue is over??
did you get the answer?
0
 
LVL 7

Author Closing Comment

by:Jeff S
ID: 33818257
Thanks
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 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