Re: ODBC driver is not found in ODBC Data Sources

Yong,

1..
Something must of go wrong with ODBC driver installation. You need some items in NT registry in order to use this driver. run Regedit and have a look at:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI you should see Oracle ODBC driver...
If not try to reinstall just a ODBC driver.

2..
You do not need a ODBC driver to link two Oracle databases. ( Even if they are running on two diferent OS. )
Look at command : CREATE DATABASE LINK ... Oracle database link is using SQL* Net or Net8 to communicate between two Oracle
databases. ( No ODBC )

HTH
Thomas Olszewicki
ThomasO_at_cpas.com
www.cpas.com

Yong Qian <yqian_at_erols.com> wrote in message news:384821EA.61FFAF38_at_erols.com...
>
> I installed the Oracle8i Client 8.1.5 and selected ODBC driver in
> particular, on two of our NTs.
>
> The problem is that the ODBC Data Source Administrator from
> CONTROL panel does not recognize the driver installed -- it is
> not in the driver list.
>
> I tried to update the NT to service pack 6. Still the same problem.
> I can see the file SQORA32.DLL in D:/ORAHOME/BIN. But
> it just does not appear in the diver list of ODBC Data Source.
>
> I want have a link from NT to the Oracle DB on the Sun server.
> I have spent most day today try to figure out why. No Success.
> I would be greatly appreciate it if anyone can provide hits or
> solution.
>
> Thanks.
>
> Yong
>
Received on Fri Dec 03 1999 - 15:14:25 CST