ODBC and password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in Access 2003. I simply want to issue a command with the ODBC
connection information that includes the password so that the user does not
have to enter it. The following represents the string I want to send.

ODBC;DSN=adage_bck;DB=adage_p;HOST=adage_bck;SERV=aifx20;SRVR=aifx20;PRO=onsoctcp;UID=mship00;PWD=mship00

Any help would be appreciated.
 
I am working in Access 2003. I simply want to issue a command with the ODBC
connection information that includes the password so that the user does not
have to enter it. The following represents the string I want to send.

ODBC;DSN=adage_bck;DB=adage_p;HOST=adage_bck;SERV=aifx20;SRVR=aifx20;PRO=onsoctcp;UID=mship00;PWD=mship00

Any help would be appreciated.
Click to expand...

Should be here somewhere... what database are you connecting to?
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForODBCDatabases
 
Back
Top