Board index » delphi » Delphi and Oracle ODBC Driver

Delphi and Oracle ODBC Driver

Anyone know how to correctly install and configure the Oracle 7.1 ODBC driver ???

I am using Delphi 1.02 (as I only have the 16bit ODBC driver)  on Windows NT connecting
to an Oracle Workgroup Server for NT 7.1 housed on the same machine. When connecting
to the Oracle database I receive a 'failed to open named pipe' error. I have no problem
with SQL*PLUS using the same alias 'p:Server:SID' .

I have reviewed simmilar postings and the solutions offered have not worked.

Thanks in advance .

Jeff

 

Re:Delphi and Oracle ODBC Driver


===========================================================
I replied e-mail to this one, Jeff said it was what he
needed so I thought I'd post it to the group - Yeah, I
know, should've done this in the first place...

Its pretty general, but it may help others having similar
struggles.
============================================================

Quote
hisco...@cadvision.com (Jeff Hiscock) wrote:
> Anyone know how to correctly install and configure the Oracle 7.1 ODBC driver ???

> I am using Delphi 1.02 (as I only have the 16bit ODBC driver)  on Windows NT connecting
> to an Oracle Workgroup Server for NT 7.1 housed on the same machine. When connecting
> to the Oracle database I receive a 'failed to open named pipe' error. I have no problem
> with SQL*PLUS using the same alias 'p:Server:SID' .

> I have reviewed simmilar postings and the solutions offered have not worked.

> Thanks in advance .

> Jeff

Which version (16 or 32bit) of SQL*Net do you have installed?
If you just have an \ORANT\BIN directory than you're 32 bit.
If you also have an \ORAWIN\BIN directory than you also have
16 bit.

If you have both directories (as I do) than the order they appear
in the PATH is *critical*!  Since everything you're doing needs
to be 16bit, make sure the \ORAWIN\BIN dir should appear before
the \ORANT\BIN in the path...

Make sense?  If I'm telling you stuff you already know,
sorry...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Chris Kasten
Programmer/Analyst

#include <std/disclaimer.h>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Other Threads