ODBC - code

[D]

Hi:

I am getting some info from an Oracle db, through ODBC; so, when the user
clicks a button the ODBC comes up with ODBCname, user, passowrd. The user ID
and psw are the same for every user.

Can you please tell me how can I do this within a code; for example when the
db opens?/to connect and refresh automatically?


Thanks,

Dan

 

[mcescher]

Hi:

I am getting some info from an Oracle db, through ODBC; so, when the user
clicks a button the ODBC comes up with ODBCname, user, passowrd. The userID
and psw are the same for every user.

Can you please tell me how can I do this within a code; for example when the
db opens?/to connect and refresh automatically?

Thanks,

Dan

Dan,
You can set the user ID and password in the properties of the query.
Open the query properties, and for the ODBC Connect Str, you should
enter something like this.

ODBC;DSN=xxYourServer;UID=xxYourID;PW=xxYourPassword

Replace the xxValues with your correct information.

Hope this helps,
Chris M.

 

[D]

Thank you Chris! but it is still asking for password?!

Dan