PDA

View Full Version : ODBC--Call Failed


saint_stevo
15-10-2008, 08:48 AM
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
15-10-2008, 09:14 AM
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
15-10-2008, 09:18 AM
Xp sp2
Server 2k3
Server using Oracle 9i
ODBC driver version 2.575.1117.00
Pancake
15-10-2008, 09:47 AM
Thats the MS for Oracle driver yeah? have you tried the version from Oracle themselves?
saint_stevo
15-10-2008, 09:50 AM
Yeah have tried both, same result
Pancake
15-10-2008, 09:53 AM
What else are you getting in return after "Call Failed"?
Pancake
15-10-2008, 09:55 AM
Try the Oracle Instant Client rather than the full client

http://www.oracle.com/technology/tech/oci/instantclient/index.html
saint_stevo
15-10-2008, 10:57 AM
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
15-10-2008, 02:33 PM
http://img516.imageshack.us/img516/5730/odbcqi2.th.png (http://img516.imageshack.us/my.php?image=odbcqi2.png)http://img516.imageshack.us/images/thpix.gif (http://g.imageshack.us/thpix.php)
Pancake
15-10-2008, 02:39 PM
Bit small (even when I click on it), but does it say cant resolve service name?
saint_stevo
15-10-2008, 03:42 PM
yeah thought it was a bit small, yeah it does say exactly that
saint_stevo
24-10-2008, 07:17 PM
ahhhh good fun, it seems i was given a horribly outdated TNS Names file!

Now all working