Home » Infrastructure » Windows » SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP
SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #99667] Tue, 12 February 2002 16:47 Go to next message
Joe Springer
Messages: 1
Registered: February 2002
Junior Member
Had a major problem, but solved it, so am posting here so that someone may benefit.
Attempting to create an ODBC DSN using Microsoft ODBC for Oracle (MSORCL32.DLL of 8/23/2001) on Windows XP (which comes with MDAC 2.7), get the following error:
"Driver's SQLSetConnectAttr failed"
Problem is that the ODBC settings expect Oracle 8.0 to be used by default. So change the registry to look for Oracle 9 DLLs and DSN creation succeeds.
Need to change 2 registry entries, see HKLMSoftwareMicrosoftMSDTCMTxOCI
and change OracleXaLib from oraclient8.dll to oraclient9.dll and change OracleSqlLib from orasql8.dll to orasql9.dll (note: if OracleOciLib is oci.dll do not change it).
(As a reference see outdated Microsoft article Q264012).
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #99812 is a reply to message #99667] Wed, 10 April 2002 06:32 Go to previous messageGo to next message
Lalit
Messages: 7
Registered: February 2002
Junior Member
I wanted to ask a question related to it.
I am working on win 98 and still when i make connection with remote database with vc++ its giving the same error. SQLSetConnectAttr Error.
Please help me correct it
Thanks.
Lalit
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #100534 is a reply to message #99667] Fri, 07 February 2003 22:18 Go to previous messageGo to next message
tuk_tik@softhome.net
Messages: 1
Registered: February 2003
Junior Member
My window XP doesn't have Microsoft ODBC .how can I find it ,please recommend.
thanks
Tik
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #100906 is a reply to message #99667] Thu, 12 February 2004 17:07 Go to previous messageGo to next message
pbhandar
Messages: 1
Registered: February 2004
Junior Member
Thank you this helped me.
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #100965 is a reply to message #99667] Sun, 07 March 2004 20:12 Go to previous messageGo to next message
david chan
Messages: 1
Registered: March 2004
Junior Member
Thank you, same problem I had!
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #101134 is a reply to message #99667] Thu, 20 May 2004 07:14 Go to previous messageGo to next message
Celine Tsang
Messages: 1
Registered: May 2004
Junior Member
Thanks very much Joe. I had exactly the same problem on Win2K and it's now resolved!!
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #101151 is a reply to message #99667] Fri, 28 May 2004 06:34 Go to previous messageGo to next message
Tony Nguyen
Messages: 1
Registered: May 2004
Junior Member
When I upgraded from Oracle 9i to 9.2.0.4, I could not do the connection. I applied the changes that Joe suggested to the registry and it worked (even though OracleOciLib is oci.dll). Thanks for the help!
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on [message #101455 is a reply to message #99667] Thu, 07 October 2004 06:49 Go to previous messageGo to next message
BenTiC
Messages: 1
Registered: October 2004
Junior Member
Thanks it worked also for me.

Creaton of DSN worked but when i tried to make linked tables in MS-ACCESS i recieved the sqlsetconnectattr error.

So i tried your tip and i worked :D. Finally

thanks A LOT!!!
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on [message #101462 is a reply to message #101455] Tue, 12 October 2004 06:59 Go to previous messageGo to next message
Martin Cubitt
Messages: 1
Registered: October 2004
Junior Member
Worked for me too, from Oracle 7.2 to Oracle 9i.

Initial prob was in VBA (Excel) using ADO.. so many red herrings.. creating DSN showed additional error info.

Thanks
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on [message #101631 is a reply to message #101134] Fri, 21 January 2005 15:57 Go to previous messageGo to next message
Lilly
Messages: 5
Registered: April 2001
Junior Member
I am having similar problems, but I am trying to connect to a different database (Not an Oracle database). How can I change the registry and how do you know what version to change it to? Thanks.
(Urgent)****Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #109510 is a reply to message #99667] Fri, 25 February 2005 02:38 Go to previous messageGo to next message
atthu
Messages: 2
Registered: February 2005
Location: Chennai
Junior Member

Hi All,

I face the same problem. I get the "Driver's SQLSetConnectAttr failed". I changed the entries as suggested by Joe.....the earlier entries were
OracleXaLib - xa80.dll
OracleSqlLib - SQLLib80.dll

I changed both to oraclient8.dll and orasql8.dll respectively. But it didn't work.

I use the personal edition of Oracle 8. If the ODBC looks for Oracle 8 by default, I wonder why I get the error then.

Any ideas??? Please advise.

Thanks,
Atthu
icon9.gif  Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #117886 is a reply to message #99667] Sat, 30 April 2005 13:21 Go to previous messageGo to next message
MaryJC
Messages: 2
Registered: April 2005
Junior Member
Worried about changing the registry. My settings are as follows:
"OracleXaLib was value data=xa73.dll" and
"OracleSqlLib was value data=SQLLib18.dll"
...apparently, both 8 and 9i are installed on my server. Oracle 8 client works and 9i does not - giving "Driver's SQLSetConnectAttr failed". Can someone guide?
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #117887 is a reply to message #99667] Sat, 30 April 2005 13:33 Go to previous messageGo to next message
MaryJC
Messages: 2
Registered: April 2005
Junior Member
After changing the registry entries, I get this in the system log:
Application popup: Microsoft ODBC for Oracle : The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.

You will be unable to use this driver until these components have been installed.
icon7.gif  Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #194327 is a reply to message #99667] Thu, 21 September 2006 09:22 Go to previous messageGo to next message
yogeshdon
Messages: 1
Registered: September 2006
Location: Pune
Junior Member

Thanks Joe. It is a great article. I had faced the same problem on Windows 2003 Server with oracle 9.2. My all other client machines with WIN-XP SP2 AND Oracle 9.2 clients were running fine. But the server was giving the same problem. I tried many solutions but could not worked.

I found your article similar and was really good one. The problem is solved within a minute. It is really amazing. Thanks once again.
icon4.gif  Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #322437 is a reply to message #99667] Fri, 23 May 2008 09:37 Go to previous messageGo to next message
rushtokapil
Messages: 1
Registered: May 2008
Location: Delhi
Junior Member
Hi,

I have done as posetd but still not able to connect oracle through Microdoft ODBC driver

Thanks
Kapil
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #385876 is a reply to message #322437] Wed, 11 February 2009 11:43 Go to previous messageGo to next message
techguy90
Messages: 2
Registered: February 2009
Location: Dallas
Junior Member
I too, tried this today - Feb 11,2009 - but with no results.

I did not yet try rebooting.

But I also had the settings of
"OracleXaLib was value data=xa73.dll" and
"OracleSqlLib was value data=SQLLib18.dll"
------
yeah, rebooted, reattempted - no luck.
I'm also getting an ORA TNS 12535 timeout error with mine, so it could also be attributed to the way I'm going through my company's proxy server I'm thinking, or the way they set their DNS lookups.

[Updated on: Wed, 11 February 2009 12:01]

Report message to a moderator

Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #385885 is a reply to message #99667] Wed, 11 February 2009 13:21 Go to previous messageGo to next message
BlackSwan
Messages: 22520
Registered: January 2009
Senior Member
I suggest you follow Posting Guidelines & SEARCH this forum for your error codes.

This really is a FAQ!
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #385886 is a reply to message #385885] Wed, 11 February 2009 13:23 Go to previous messageGo to next message
techguy90
Messages: 2
Registered: February 2009
Location: Dallas
Junior Member
sorry -- didn't realize I did something wrong or out of protocol.
Re: SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #385888 is a reply to message #99667] Wed, 11 February 2009 13:30 Go to previous message
BlackSwan
Messages: 22520
Registered: January 2009
Senior Member
How can you miss the bouncing RED ball in URL below?

http://www.orafaq.com/forum/f/32/136107/
Previous Topic: Run Remote Server Access on Vista 64 bit
Next Topic: Oracle 10g Installaion
Goto Forum:
  


Current Time: Tue Jul 29 04:46:53 CDT 2014

Total time taken to generate the page: 0.12026 seconds