saint_stevo Posted 15 October, 2008 Share Posted 15 October, 2008 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? Link to comment Share on other sites More sharing options...
Pancake Posted 15 October, 2008 Share Posted 15 October, 2008 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? Link to comment Share on other sites More sharing options...
saint_stevo Posted 15 October, 2008 Author Share Posted 15 October, 2008 Xp sp2 Server 2k3 Server using Oracle 9i ODBC driver version 2.575.1117.00 Link to comment Share on other sites More sharing options...
Pancake Posted 15 October, 2008 Share Posted 15 October, 2008 Thats the MS for Oracle driver yeah? have you tried the version from Oracle themselves? Link to comment Share on other sites More sharing options...
saint_stevo Posted 15 October, 2008 Author Share Posted 15 October, 2008 Yeah have tried both, same result Link to comment Share on other sites More sharing options...
Pancake Posted 15 October, 2008 Share Posted 15 October, 2008 What else are you getting in return after "Call Failed"? Link to comment Share on other sites More sharing options...
Pancake Posted 15 October, 2008 Share Posted 15 October, 2008 Try the Oracle Instant Client rather than the full client http://www.oracle.com/technology/tech/oci/instantclient/index.html Link to comment Share on other sites More sharing options...
saint_stevo Posted 15 October, 2008 Author Share Posted 15 October, 2008 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 Link to comment Share on other sites More sharing options...
saint_stevo Posted 15 October, 2008 Author Share Posted 15 October, 2008 Link to comment Share on other sites More sharing options...
Pancake Posted 15 October, 2008 Share Posted 15 October, 2008 Bit small (even when I click on it), but does it say cant resolve service name? Link to comment Share on other sites More sharing options...
saint_stevo Posted 15 October, 2008 Author Share Posted 15 October, 2008 yeah thought it was a bit small, yeah it does say exactly that Link to comment Share on other sites More sharing options...
saint_stevo Posted 24 October, 2008 Author Share Posted 24 October, 2008 ahhhh good fun, it seems i was given a horribly outdated TNS Names file! Now all working Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now