ODBC Connection string

[Rajesh Candamourty]

Dear ALL,

I have an access database with one of the combo ox boxes connected to Oracle
via ODBC driver with a system DSN. So each and every time the user clicks on
the combo box, a screen appears and asks for the username, password and
server. I wish to do this in my code, like in the Form Load to have the
username, password and server entered and ready to use.
I would be very comfortable if anyone know how to do this in VBA.
Or let me know if u can find this stuff in any websites.
I appreciate ur help.

Thank you.
Raj.

 

[Kirk P.]

In the past, I've created a simple SQL pass-through query, in which you can
embed the ODBC connect string. Call this query upon opening of the database
using the Autoexec macro. This will force the database to ask for ODBC
connection information up front, and the user won't be asked for it when
interacting with the combo box.

 

[Sharkbyte]

Rajesh:

This is not that difficult, but may be impacted by your companies network
security policies...

Rather than linking the combo box directly to the Oracle table, use ODBC to
link the table to your database, and tie the combo box to the linked table.

Also, when you create the link, after you give your username/password, the
table select window appears. On the lower-right is a checkbox for
remembering password. Check this, before you link the table. Then Access
will always pass the password to Oracle, for your users.

HTH

Sharkbyte

 

[Van T. Dinh]

I am not 100% sure since I mainly use DSN to MS SQL Server but with the ODBC
Manager in System Administration, there are options regarding User /
Password in the second dialog of the ODBC Manager when I try to create /
configure the DSN.