New to connection strings
Have a small ap that otheres want to use. Originally the ap was connected to SQLServer Express R8 via odbc with linked tables (only use 2 of the 50 tables in the db) and it works fine. Now that others want to use the ap I need to get to the server via connect string, and have the log in with username and password automatic. The ap is read only.
So far I have this:
Dim strConnect As String
strConnect = "Driver={SQL Server Native Client 10.0};Server=JOHN-PC\SQLExpress;Database=NameTran;Uid=John-PC\John;Pwd=Constance;"
But now I don't know how to execute the open.
Sure there will be more questions.
Any heilp will be greatly appreciated
jpl
So far I have this:
Dim strConnect As String
strConnect = "Driver={SQL Server Native Client 10.0};Server=JOHN-PC\SQLExpress;Database=NameTran;Uid=John-PC\John;Pwd=Constance;"
But now I don't know how to execute the open.
Sure there will be more questions.
Any heilp will be greatly appreciated
jpl
Selected Articles