ODBC and password

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.
 
P

pietlinden

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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top