Solved

SQL 2005 Error - Connecting Excel workbook to SQL 2005 server

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
In this article I will describe the Copy Database Wizard 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.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

895 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

18 Experts available now in Live!

Get 1:1 Help Now