From Windows XP SP1 I have decided to shift to XP SP2(not by update), I have set the port 1433(example only) in the exception of windows firewall. To my surprise I can no longer connect to the server using TCP/IP Protocol(DBMSSOCN).

This is my code in Visual Basic 6

    If chkNT.Value Then
        pstr = ";integrated security=sspi"
    Else
        pstr = ";User ID=" & txtUser & _
        ";Password=" & txtPassword
    End If

   mconnstr = "Provider=sqloledb;" & _
              "Network Library=DBMSSOCN;" & _
              "Data Source=" & txtIpAddress & ",1433;" & _
              "Initial Catalog=Mydatabase" & pstr


Even if I turn off the firewall I cant connect, What are the other things that I must configure.:crying:



Proud To Be Pinoy

__________________
Proud To Be Pinoy