ODBC - code

  • Thread starter Thread starter D
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
Back
Top