Opening an ODBC DB connection w/o pw prompt

[Guest_imported]

I have a C++ program using the ODBC connection
to a SQL 7 database. It runs multiple threads
each adding records to the database. The program is
using multiple instances of the CRecordset class
to access the database. Each "open" of the database
forces the user to click the OK for the password
dialog box.

How can I set it up to allow the program to gain assess
to the database without requiring the password dialog
box action?

Can the program pass the password somehow?

Thanks,

John Taylor jtc@ee.net

 

[Nickman]

Hi

If you are using DSN, then this is one possibility:

connectme = "DSN=DBName;UID=U1;PWD=u1"

Hope you can use it too.

regards
Nick