Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with ODBC on NT4 running Oracle7
Hi Carl,
did you include '%oracle_home%\bin' in your path-variable?
Carl A Dalessandro wrote:
>
> For any of the oracle wizards out there...
>
> I have installed Oracle7 along w/ SQL*Net and the Oracle ODBC
> drivers (as per instructions on the Oracle demo CD).
> I have an active Oracle db running and all the admin functions work.
>
> What I am trying to do, is connect to an Oracle7 db from Active
> Server Pages using the Oracle ODBC drivers. So far, all that I
> get is an error stating the following...
>
> SQLSTATE: 08003
> Native Error Code:0
> Driver Message:[Oracle][ODBC Oracle Driver] Connection not Open.
>
> then...
>
> SQLSTATE: 01000
> Native Error Code: 0
> Driver Message:[Microsoft][ODBC Driver Manager] The driver returned
> invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: %
>
> and then...
>
> SQLSTATE: S1000
> Native Error Code: 3121
> Driver Message:[Oracle][ODBC Oracle Driver][Oracle OCI] ORA-03121:
> no interface driver connected - function not performed
>
>
> All that is from the ODBC Test app.
> The ODBC drivers have been installed; the db has been added in the
> NT ODBC Admin app(under System DSN) and SQL*Net2.3.2.1.3 is installed
> along with the Oracle7 server. I really do not know why I continue
> to get these errors.
> From the browser, I get an error that states that it cannot
> open the db. It seems that it has found the database, but cannot
> access it properly (yes, I even included the UID and Passwords)
>
>
> I appreciate any help that is offered. Thanks in advance.
>
> -Carl D'Alessandro
> Cymfony Net, Inc.
-- Regards Matthias Gresz :-)Received on Mon Jan 26 1998 - 00:00:00 CST