Quote:> 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.
Quote:> 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
> www.cpas.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
by