Connect string to SQl data

[richardb]

I have been using the following connect string via an ODBC DSN. I cannot
remember the variation on this to connect directly via the server name and
database name, not via a DSN. I think I need to remove the DSN and replace it
with a server name. I'd appreciate someone's reminder, with thanks:

..Connect = "ODBC;DSN=PPM_700;Description=PracticePoint Manager
V7;Network=DBMSSOCN;UID=Admin;PWD=MPYVqkN^ykb~L}u;DATABASE=Medical Office
Solutions;"

 

[richardb]

I found the answer at CarlProthman.net - listing of connection strings.

"ODBC;Driver={SQL Native Client};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"