Solved

SQL 2005 Error - Connecting Excel workbook to SQL 2005 server

Posted on 2010-09-17
5
448 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

746 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

13 Experts available now in Live!

Get 1:1 Help Now