EXPERT RESPONSE
This code can be used for the connection:
Public adoconn as ADODB.Connection
Sub main()
Set adoconn = New ADODB.Connection
adoconn.ConnectionString = "Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=m yPassword;"
adoconn.Open
End Sub
|