ODBC--Call Failed

[saint_stevo]

Trying to point MS Access 2000 at a server to view a database, have added the Oracle for Windows ODBC driver and installed an Oracle client but when i run the query i get "ODBC--Call Failed"

 

Any ideas?

[Pancake]

Trying to point MS Access 2000 at a server to view a database, have added the Oracle for Windows ODBC driver and installed an Oracle client but when i run the query i get "ODBC--Call Failed"

 

Any ideas?

 

Client OS?

Server OS?

Database software (Im assuming Oracle) and version

Driver version?

[saint_stevo]

Xp sp2

Server 2k3

Server using Oracle 9i

ODBC driver version 2.575.1117.00

[Pancake]

Thats the MS for Oracle driver yeah? have you tried the version from Oracle themselves?

[saint_stevo]

Yeah have tried both, same result

[Pancake]

What else are you getting in return after "Call Failed"?

[Pancake]

Try the Oracle Instant Client rather than the full client

 

http://www.oracle.com/technology/tech/oci/instantclient/index.html

[saint_stevo]

Try the Oracle Instant Client rather than the full client

 

http://www.oracle.com/technology/tech/oci/instantclient/index.html

 

I'll give it a go, and if i can find the full error message will post that up too

 

 

Cheers

[saint_stevo]

[Pancake]

Bit small (even when I click on it), but does it say cant resolve service name?

[saint_stevo]

yeah thought it was a bit small, yeah it does say exactly that

[saint_stevo]

ahhhh good fun, it seems i was given a horribly outdated TNS Names file!

 

Now all working