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

0 answers