VB.Net SQL2000 a transport error has occurred when sending the request to the server WSAStartup

Russell_Harper
Russell_Harper used Ask the Experts™
on
I have a VB.Net application that connects to a SQL 2000 back end (running SQL Personal Edition with SP4 applied).  I am intermittently getting the following error:

System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - Either the application has not called WSAStartup, or WSAStartup failed.)

I've tried referencing the server in my connection as 127.0.0.1 as opposed to the server name and tried clearing the connection pool everytime I close the connection to the server using SqlConnection.ClearAllPools()

Any ideas on what I can try?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I think your SQL server is not responding.  Pls. try to connect your server using SQL Server Management Studio or similiar tool.

Top Expert 2012

Commented:
It simply means you have lost your connection to SQL Server.  Try again.

Author

Commented:
There's nothing in Event View or the SQL Server logs to suggest this...
Commented:
I was searching on the net and found the following possible solutions that may help to you...
try them each and see if it is solving your problem if you still haven't tried!

1. First try replacing 127.0.0.1 with local NOT localhost.

2. Open your Sql Server Configuration Manager go Sql Native Client Configuration -> Protocols and disabled Shared Memory and made the TCP/IP protocol #1 in order. Then just restarted the Sql Service

3.
- Backup and delete the following registry keys
             HKEY_LOCAL_MACHINE\System\CurrentControlSet\Servic es\Winsock
             HKEY_LOCAL_MACHINE\System\CurrentControlSet\Servic es\Winsock2

- Reboot
- Go to the network connections folder, right click the icon for your network connection, and select properties.
- Click install, choose "protocol", and click "add..."
- Click "Have Disk...", enter "\windows\inf", click OK
- Select "Internet Protocol (TCP/IP), click OK
- When the process in complete, reboot


Hope one of these works!
Top Expert 2012

Commented:
>>There's nothing in Event View or the SQL Server logs to suggest this... <<
Why would you expect to see it in your Event log?  Just pull the network cord for your workstation and you can duplicate the problem.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial