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.