You can start by reading this: http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
You might also try toying around with these connection string parameters.
1. Add "Connection Reset=false;" to your connection string.
2. Try a different network library. Use "Network...
I recently had this problem as well. First I did a re-install. When that didn't work I completely removed Visual Studio 6 and installed it again but to no end.
Then I stumbled upon a microsoft knowledge base article (248675) concerning this problem...
Why don't you just execute the batch as a whole?
Public Sub ExecuteBatch(ByVal vntStatementArray As Variant)
'* Enable error handling
On Error GoTo errHandler
'* Declare variables
Dim strSQL As String
Dim objConn As New ADODB.Connection
'* Join the array...
Set the website to Basic authentication instead of Integrated Windows authentication.
Control panel -> Administrative tools -> Internet services manager. Then right click the website -> Properties -> Directory security -> Edit
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.