Greetings,
hello all am new to Vb I am connecting to sql server which is in different machine but when i use the code below its giving me an error sql not server not found
please suggest me how to proceed further.
Dim cn As New ADODB.Connectio n
Dim provStr As String
' Specify the OLE DB provider.
cn.Provider = "sqloledb"
please let me know what are pre-req i have to follow in connecting. i.e driver connection preferences to be added. :)
' Specify connection string on Open method.
ProvStr = "Server="MAchin e IP address";Databa se=employee;Tru sted_Connection =yes"
cn.Open provStr
hello all am new to Vb I am connecting to sql server which is in different machine but when i use the code below its giving me an error sql not server not found
please suggest me how to proceed further.
Dim cn As New ADODB.Connectio n
Dim provStr As String
' Specify the OLE DB provider.
cn.Provider = "sqloledb"
please let me know what are pre-req i have to follow in connecting. i.e driver connection preferences to be added. :)
' Specify connection string on Open method.
ProvStr = "Server="MAchin e IP address";Databa se=employee;Tru sted_Connection =yes"
cn.Open provStr