all groups > sql server odbc > may 2004 >
You're in the

sql server odbc

group:

Random errors


Random errors Sebastian Piccolotto
5/26/2004 12:24:44 PM
sql server odbc:
I have a VB6 Dll wich connect with SQL Server through ADO.
The dll is called from ASP pages.
The application works correctly in many servers, but I
have one server that give me several errors.

Sometimes I receive this error:
[Microsoft][ODBC SQL Server Driver]Communication link
failure

Another times I receive the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionWrite (send()).

The code to open a connection seems:
[Code]
....
ADOConn.CommandTimeout = 0
ADOConn.ConnectionTimeout = 0

ADOConn.Open "DSN=DSN1;uid=sa;pwd=123"
ADOConn.Execute ("SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED")
....
[/Code]

Anybody can help me with this problem?
Thanks in advance.


Random errors anonymous NO[at]SPAM discussions.microsoft.com
5/26/2004 1:41:48 PM
More info:
* Web Server has MDAC 2.5 SP3
* SQL Server 2000 SP3a - This server has MDAC 2.6 RTM

Regards
Sebastian

[quoted text, click to view]
AddThis Social Bookmark Button