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.

The driver is not listed. Re-install yielded same results. Re-installation is done automatically by Oracle installer. I also downloaded and installed the ODBC driver from oracle download site, following the installations. The results are the same.

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

The problem is we need to access the Oracle DB on SUN from NT, where we plan to use MS Access/ODBC to connect the database on sun.

Thanks for the help.

Yong

>
> 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:54:05 CST