OraFAQ Forum: Windows » SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP

Home » Infrastructure » Windows » SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP [message #99667]

Tue, 12 February 2002 16:47

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).

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

pbhandar
Messages: 1
Registered: February 2004

Junior Member

Thank you this helped me.

Report message to a moderator

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

david chan
Messages: 1
Registered: March 2004

Junior Member

Thank you, same problem I had!

Report message to a moderator

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

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!!

Report message to a moderator

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

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!

Report message to a moderator

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

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!!!

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

(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

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

Report message to a moderator

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

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?

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I suggest you follow Posting Guidelines & SEARCH this forum for your error codes.

This really is a FAQ!

Report message to a moderator

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

techguy90
Messages: 2
Registered: February 2009
Location: Dallas

Junior Member

sorry -- didn't realize I did something wrong or out of protocol.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How can you miss the bouncing RED ball in URL below?

http://www.orafaq.com/forum/f/32/136107/

Report message to a moderator

Previous Topic:	Run Remote Server Access on Vista 64 bit
Next Topic:	Oracle 10g Installaion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 11:03:02 CST 2024