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?