error using Microsoft ODBC for Oracle

Are you able to connect to the DB using sqlplus or any other tool?

Yes, using the net configuration I am able to connect but not any tool using ODBC.

Are you using ORAOLEDB or MSDORA?

Neither, I am not trying to do this programmatically.  I am simply using Microsoft ODBC Data Source Administrator - System DSN - Microsoft ODBC for Oracle (MSORCL32.DLL).  I have to use Microsoft's ODBC with the database.  But when I try to use it using Winsql, Access, or Oracle ODBCTest utility I receive the above error.  I verified other machines can connect to the database fine using same method.  It is something specific with this XP machine.

Hi MillenniumPSG

try to install the ODBC again from the firist CD Of Oracle Database Chose the custom install and chose the ODBC only

from tareq

Check the solution on this forum -

SQLSetConnectAttr error : Microsoft ODBC for Oracle, and Oracle 9i client on XP
http://www.orafaq.com/forum/t/37835/2/

Also,
https://www.experts-exchange.com/questions/21887808/ODBC-ERROR-Using-MS-ODBC-for-Oracle.html

First, I am not using the Oracle in OraHome92 ODBC so reinstalling that from the CD won't help.  I am using Microsoft's ODBC for Oracle which I believe uses MDAC.  I have to use Microsoft's ODBC for the application to work.  I have verified I have version 2.8.

Second, for the two links to solutions provided I have already tried changing the registry.  I mention this at the beginning.  It still did not work.

I think the only part that has not been explored is reinstalling MDAC 2.8 (maybe that is corrupt) but I don't know how to do that.

Sorry I should read your question again before posting a solution.

MillenniumPSG, is there any other error msg that shows up before or after the error you posted ? maybe an oracle error ?

No Oracle errors but another error that appears is:

SQLSTATE: NA000
Native Error Code:0
Driver Message:[Microsoft][ODBC driver for Oracle]

Not as descriptive as the first.  I think Oracle is working fine since I can use the net configuration to connect and ODBC from other machines to connect.  It is something with the ODBC connection on this machine.  Whether the MDAC is corrupt or I need to replace the MSORCL32.DLL used by the Microsoft ODBC driver.