ODBC -- call failed

Additional line for error message is:

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)

I am trying to link to Oracle tables (I have tried both Oracle 9 and Oracle 10) in MS Access, but get this error.

Any ideas?

Thanks.
multimodalAsked:
Who is Participating?
 
sventhanCommented:
Bring the DLL's up to date. In the registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient10.dll"
"OracleSqlLib"="orasql10.dll"
"OracleOciLib"="oci.dll"
0
 
sventhanCommented:
SOLUTION:
----------

This error indicates that the client PC is unable to interpret the
HOST name supplied in the data source under SERVER.  

Try and PING the host name from the DOS prompt.  If it does not respond, then
the PC does not have the host name set up in the network HOSTS file or in
the DNS server.  Seek network assistance to configure the network on the client so that the client will recognize the host name.

WORKAROUND:
------------

Use the IP address for the HOST you are trying to connect to in the
SERVER field of the data source for your connection.


0
 
Mark GeerlingsDatabase AdministratorCommented:
We have used ODBC connections to both Oracle9 and Oracle10 databases, and we have used ODBC drivers from: Oracle, Microsoft and Merant (with different applications) so it certainly can be done.

Which ODBC driver are you using?  Do you have the Oracle client software installed, or do you prefer to get this working without using the Oracle client software?  I think that is possible with the Merant driver, I'm not sure if that is possible with the Microsoft ODBC driver for Oracle or not.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
multimodalAuthor Commented:
I can connect successfully by PINGing and also via SQL Plus.

If I try to connect to the data via MS Access, I get the error listed in the original message.  If I try to connect via our own Oracle-based software (we're in the transportation software and consulting field), I get the following, which I assume is a related error:

"4: Unable to connect: Oracle error occurred, but error message could not be retrieved from Oracle"

Does this help any?

Thanks!
0
 
Mark GeerlingsDatabase AdministratorCommented:
If you can connect via SQL*Plus, then you have at least one "Oracle_home" (a version of the Oracle client software)  installed.  Do you have just that one version of the Oracle software installed, or do you maybe have multiple Oracle_homes, with the networking configured correctly in the one that SQL*Plus uses, but not in the one that ODBC uses?

Which ODBC client are you trying to use (Microsoft's, Oracle's, some other one, etc.)?
0
 
sventhanCommented:
0
 
multimodalAuthor Commented:
markgeer:

We have Oracle Client version 10.1 installed, and are using the Microsoft ODBC driver for Oracle. I was told by the developers here that we need to use the MS driver.

Thanks.

0
 
multimodalAuthor Commented:
We only have one version of Oracle client installed (10.1), and are trying to connect through Microsoft's ODBC driver for Oracle.

We did have a previous version of Oracle installed (10.2), but uninstalled it and installed 10.1 instead. 10.2 was mistakenly installed by the user of this laptop. (Everyone else here has 10.1.) Is it possible that the MS ODBC driver or configuration is somehow corrupted? Can it be reinstalled? Sorry, I don't know very much about this.

Thanks.
0
 
Mark GeerlingsDatabase AdministratorCommented:
We have used both Oracle10.1 ODBC driver and the Microsoft ODBC driver for Oracle with our Oracle10.1 database.  I am not an expert with either one, and don't need either one for my work (as a DBA, and with Oracle client tools) but I have helped to install and configure both of these for others in our organization who want to use Oracle data with non-Oracle apps.  Have you tried the Oracle ODBC driver?  Do you know why the developers "need" the MS driver?
0
 
sventhanCommented:
do you have the db home in the PATH. Just try to move it to first in the path and see if that would help.
0
 
multimodalAuthor Commented:
Yes, it is in the path, and it is first.
0
 
multimodalAuthor Commented:
I checked the registry, and could not find "[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]". Could this be part of the problem?

Thanks

0
 
linuxoCommented:
Hi,

your problem is in your ODBC i think,  try to download Oracle driver

this will solve this issue

http://www.oracle.com/technology/software/tech/windows/odbc/index.html


thanks
0
 
multimodalAuthor Commented:
Just for the heck of it (I figured it was worth a shot, anyway), I exported the registry that "sventhan" suggested I update. I then made the modifications as suggested, and TADA!!! I can now connect using the MS ODBS driver.  Thanks sventhan!
0
 
sventhanCommented:
You're welcome.
Happy to know that its working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.