Re: Oracle ODBC Driver not listed

dfs001_at_yahoo.com (Dale Shultz) wrote:

> Hi John,
>
> You should have a registry entry under HKLM/Software/ODBC/odbcinst.ini
> which points to your driver at ORACLE_HOME/bin/sqora32.dll.
>
> - Dale Shultz

I ran into the same problem recently, and all of the registry settings were fine. It looks to me like a bug in the 3.52 Microsoft ODBC manager, that doesn't necessarily list all of the good drivers. My evidence for this is that there were other drivers that used to be visible but have now vanished after (something?) was upgraded. Completely purging the Oracle registry and re-installing had no effect. I suspect M$oft.

I finally had to create a DSN (call it MyDSN) for my driver by creating a DSN "MyDSN" for another (listed) driver, and then go into REGEDT32 and editing the registry key

  HKLM/Software/ODBC/ODBC.INI/MyDSN Driver

and setting it to the appropriate SQORA32.DLL path, and then editing

  HKLM/Software/ODBC/ODBC.INI/ODBC Data Sources/MyDSN

and changing its value to "Oracle in OraHome81" or whatever your oracle driver is named. Then you can go into the ODBC Driver manager and configure that System DSN with the appropriate configuration logic.

It works just fine!

  --Niles.

>
> "John Roberts" <namaste3_at_home.com> wrote in message news:<Xb_E7.12313$ly1.1697053_at_news1.rdc1.va.home.com>...
> > Hello all
> >
> > I have an Oracle Client machine (8.1.7) that used to be a 8.0 client. The
> > older client wasn't cleanly un-installed (don't ask...). Anyhow, after
> > installing 8.1.7 I still don't see the driver listed in my ODBC list in
> > Control Panel. Is there a reg key I need to add, or a file that I can
> > edit/create that the installer failed to update? Procedures to totally
> > remove the client software/reg keys and start over?
> >
> > TIA
> >
> > - John
Received on Thu Nov 08 2001 - 19:29:58 CST