Re: Oracle ODBC Driver 1.15.0301 Problem. Please help.

WPL (lao2_at_total.net) wrote:
: 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.

I have been chasing what looks like exactly the same fault, although using sql*net2 the above looks like sqlnet1, after playing around I found that I had one machine that worked, W95 and Office95.

Talking to Oracle and Microsoft I think the problem is introduced with Office97 which upgrades the ODBC administrator function. The upgrade supports ODBC drivers compliant with 2.x and 3.x specs, the Oracle drivers are 1.1 spec. If your ODBC admin manager is the 3.0 version you have a problem, if it is 2.5 then it is said this supports the Oracle ODBC driver. Visigenic may have a ODBC driver that solves the problem, I have also heard that Oracle have an updated driver but have not seen it yet.

There is a Microsoft Knowledge Base article Q140498 which gives some useful information.

I have yet to get my machines connected. Any input welcome.

Gordon.

--
Gordon Johnstone                                          gordon_at_etx.com.au
ETX Consultants						Ph: +61 3 9521 1977
Personnel Consultants                                   Fax +61 3 9510 3944
Melbourne Australia                                   http://www.etx.com.au