linking oracle to access

  • Thread starter Thread starter Miikka Hamalainen
  • Start date Start date
M

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
 
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
 
Back
Top