Oracle ODBC Driver 1.15.0301 Problem. Please help.

Hi. I'm having a bit problem with the ODBC connectivity.

I'm running NT4 server with SP2, oracle server 73

Here is what happens when i do a 'start' in LSNRCTL>

>LSNRCTL> start
>Starting tnslsnr: please wait...
 

>Service OracleTNSListener start pending.
>Service OracleTNSListener started.
>TNSLSNR for 32-bit Windows: Version 2.3.2.1.4 - Production
>System parameter file is C:\ORACLE\network\admin\listener.ora
>Log messages written to C:\ORACLE\network\log\listener.log
>Trace information written to C:\ORACLE\network\trace\listener.trc
>Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
>Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
>Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\LARK\pipe\ORAPIPE))
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=176)(HOST=192.168.1.2)(PORT=1521))
>Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=160)(HOST=192.168.1.2)(PORT=1526))
 

>Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
>STATUS of the LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for 32-bit Windows: Version 2.3.2.1.4 - Produc
>tion
>Start Date 10-MAR-97 04:09:22
>Uptime 0 days 0 hr. 0 min. 1 sec
>Trace Level admin
>Security ON
>SNMP OFF
>Listener Parameter File C:\ORACLE\network\admin\listener.ora
>Listener Log File C:\ORACLE\network\log\listener.log
>Listener Trace File C:\ORACLE\network\trace\listener.trc
>Services Summary...
> ORCL has 1 service handler(s)
>The command completed successfully

Everything so far seems ok.

In control panel, my "WEB SQL" system DSN has a connect string as follows:

t:127.0.0.1

or

t:192.168.1.2

(tried both)

now, i goto the oracle ODBC test utility and try to connect to this "WEB SQL" DSN, i get 3 error messages:

>SQLSTATE: 08003
>NATIVE Error Code: 0
>Driver Message:[Oracle][ODBC Oracle Driver]Connection not open
 

>SQLSTATE: 01000
>Native Error Code: 0
>Driver Message:[Microsoft][ODBC Driver Manager] The driver returned invalid (or failed to return)
>SQL_DRIVER_ODBC_VER: %s
 

>SQLSTATE: S1000
>Native Error Code: 3121
>Driver Message: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-03121: no interface driver connected - function not performed.

I know I probably did something really stupid, but just don't know where to start :(

I tried to connect to other DSN's such as ms access files, no problem. But the oracle one just doesn't work for me. By the way, I know I have entered a valid correct username and password after I pressed the "connect" button. Then I get the 3 error messages.

thanks in advance. Received on Mon Mar 10 1997 - 00:00:00 CST