linked tables from an Oracle database

[OhioSteve]

Our company an Oracle database on a server. Two years ago, I used ODBC to setup a link between that Oracle db and an Access DB on my PC. Now the company has given me a new PC. Obviously I need to redo the link. Unfortunately, I have totally forgotten how to do it. I recall that you go to control panels/administrative tools/data sources (ODBC). I don't know how to proceed after that.

Please advise.

 

[willir]

You need to install the ODBC driver for Oracle. You can install the driver from the Oracle install disk or elsewhere (such as the Oracle site).

How you configure the Oracle ODBC client will depend on needs. Before you being, you will need to know the Oracle instance name (ORCL is the default, but if the DBA is worth their weight in support, they will have set something else up), a login account and password.

Assuming you have Windows 2K or XP, from the menu, "Start" -> "Control Panel" -> "Administrative Tools" -> "Data Sources ODBC"

You will have your choice in the ODBC setup -- User, System or File". A typical approach is to use the "System DSN". Click on "Add" and locate the Oracle driver. Follow through with the wizard. You will be given a chance to test the connection.

Once you have established the ODBC driver / connection, you will be able to use Access to access the database.

Ricard

 

[OhioSteve]

I did all that. I even found the right drivers and installed them. After the installation, I saw the new driver in the ODBC interface. Unfortunately we can't use the ODBC link on any workstation. We can use it on the server that holds the Oracle DB. The new version of Oracle is 10g. We migrated from 8 to 10g.