Search code examples
sqlvb6sql-server-2000

[Microsoft][ODBC SQL Server Driver]Communication link failure

I need your help on this guys!!!!

During the upload of the files to a database, this error occurs. [Microsoft][ODBC SQL Server Driver]Communication link failure

Now here's what I did so far based on the articles which I've been reading. 1. I restarted the servers that are involved. 2. I've added a new DNS connection to pattern to what they are using to connect to the database.

But all of these failed. I don't know what to do because this is now critical and it's been a week now.

Please help me...

Solution

  • try this one, it work for me......

    Set Cnn = New ADODB.Connection
Cnn.Open "Provider=SQLNCLI10;Server=" & txtServer & ";Database=" & cmbDatabase.Text & ";MARS Connection=True;DataTypeCompatibility=80;UID=" & txtUser & ";PWD=" & txtPassword & ";"