ODBC connection

[avicenna]

Hi all,

I have an issue regarding creating ODBC connection to an oracle DB.
I need to create reports that use different tables (stored on Oracle DB). this access will be placed in several machine and users will users will use it to print out the reports with up-to-date data.

I've search about how to create an ODBC connection from the admin tools; but things not ending as expected.

If someone gives me details steps how to create an ODBC connection so my access program will be able to connect to the oracle db to retrieve the up-to-date data, i will really appreciate it.

assuming that my oracle db username:guest; password: welcome
what is the required steps to do that? what are the things required to be done to keep the access file working in any machine?



Thanks a lot

[pkstormy]

I don't think there's an oracle driver in the ODBC that ships with Microsoft.

I think you'll need to download/install the ODBC Manager by Progressive. I can't recall the steps using the Progressive ODBC manager but you can view the help on this.

[Matrix]

Alternatively, you can install OracleODBC driver and then try:

Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN > Add > Microsoft ODBC for Oracle.