linking oracle to access

[Miikka Hamalainen]

Hi There,

I have trouble linking tables from oracle db to access. I would like to make
easy queries and reports for work purposes.

I have added tsnnames and created ODBC for Access in control panel.

When i try to get external data from Oracle to access, I receive ODBC call
failed-error message.

Do I have wrong set up or...?

/Miikka

 

[MH]

In no particular order:

- Ensure that the problem does not lie with your data, date fields are
particularly bad as the driver just returns an error, no records!
- Try different ODBC drivers.

If niether of the above work, post back in this thread.

MH