Access Oracle via MS Access

[theinvid]

How would you setup MS Access to link to Oracle database, so where you can generate reports. Can you setup it up via ODBC (MS or Oracle)? thanks.. Oracle is on a NT, client is on win2k. Oracle 8.1.7

 

[THoey]

Yes, create an ODBC connection on the PC side (Oracle Client must already be installed). Then, in Access, FILE --> GET EXTERNAL DATA --> LINK TABLES. Change the type to ODBC connections, select the connection you made, enter the login and password (and the option to save the password if you want), select the tables you want to link, select any primary key fields for those tables, and you are done. Takes about 2 minutes... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[theinvid]

Can you do ODBC without Oracle client install?

 

[Turkbear]

No..
Unless you have the newest DataDirect ( formerly part of Merant) ODBC drivers ( they use a WIRE protocol which is similar to a JDBC Thin connection)
hth,

 

[theinvid]

ok, i config, net8 to the database. now which odbc should i config next: user dns, system dns, file dns?

 

[njtornado]

You do not need to install the Oracle to create the odbc connection to link an Oracle db to MS Access. You can use the Microsoft odbc driver for Oracle. In Windows 2000 this is under control panel-administrative tools-data sources(odbc).

You can download updated drivers from Microsoft by going to their download page and looking for product name MDAC.

Good luck!

-Theresa

 

[njtornado]

By the way we use MS Access on Win2K to connect to an Oracle 8.1.7 db...

Seems obvious to me but make sure you make the odbc changes to the client machine!

 

[Turkbear]

AFAIK, The Microsoft ODBC Driver for Oracle NEEDS the Oracle Client to work with any non-local ( that is one not on the same workstation as the driver) Oracle database...Without SqlNet any 'fat client' driver will not have any idea where to find the Oracle database listener or how to communicate with it..

 

[THoey]

Theinvid,

We put ours in the System DSN. If you only want one particular user on that machine to be able to see it, use the User DSN... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...