Link to Info

[rpbenito]

Im an intern for this summer....my mentor is gone for the week....could anyone give me info or link to a site that has GOOD information on how to connect to and Oracle database and run queries on this db from Access? I've been pulling my hair out...Microsoft just doesn't give good info on connecting via ODBC and working with it.


THank you

 

[ninfan]

The quick answer is to use your mentor's computer if you can. LOL. Connections to Oracle via ODBC are very machine specific. As an example, here is what I do for each machine in our office that needs to be connected to Oracle:

- Install Oracle client on PC (this makes the Oracle ODBC driver available)
- Update TNSNAMES.ORA to include references to the Oracle DB
- Add ODBC connections to the Oracle DB (through the Control Panel)

If you've done this correctly, an Access DB that already has the links should work for you. If you need to link to the Oracle tables yourself, you need to use the Linked Table wizard. This may or may not be installed on your machine. If not, you have to install it from your Office CD.

May the force be with you.

Troy

 

[Aivars]

Hi!

See at thread705-96231
Maybe something of them would help you?

Aivars

 

[S3066]

rbenito ... Did you ever resolve your ODBC questions?

I have had similar troubles.