ora-3121 when trying ODBC under win95

From: Jakob G}rdsted <pilgrim_at_daimi.aau.dk>
Date: 1996/07/26
Message-ID: <4t9u74$oq1_at_gjallar.daimi.aau.dk>#1/1


Hi. I work at a software company where we connect to oracle databases on netware, from win95 machines. The communication takes place with SQL*Net SQLSPX. This works just fine. I can log onto the servers in SQL Studio, SQL Plus, and Q&E (and, surprise, with our own applications).

But then we have acquired Optima++, a Delphi/Visualbasic RAD tool. And it requires ODBC. So I start out to setup ODBC. I've tried several. The one I'm currently trying is that 8MB(expands into >20 MB) "win95 odbc driver" I found at oracle.com.

But so far, I get "ora-03121: No interface driver connected - function not performed", no matter what I think of.

The strange thing is, I can still log into the above mentioned programs with no problems.
Thinking it might have something to do with Netware, I decided to install SQL*Net for windows 95 (until now, I've used SQL*Net for windows under win95).

It turned out, I had to change my netware client from 16bit to 32bit. So I did that. The 32bit netware client seems to work OK as netware driver.

So I proceed to install SQL*Net for win95 SQLSPX from the Personal Oracle 2000 CD. That seems to work OK too. (even though it only seemed to install files and directories - no inifiles or such was altered ?!).

I have a variable CONFIG set to c:\orawin\oracle.ini

Also, in win.ini, I have the oracle setting pointing to the same file (If I do not, the abovementioned "good" programs stops being able to connect to oracle).

I have c:\orawin\bin in my path.

For "fun", I tried changing my path, so I instead referred to d:\orawin95\bin. Also, I changed references to c:\orawin\xzz to d:\orawin95\xxzz . It changed nothing - SQLStudio, sql plus, and q&e, and our own applications continued to work, and ODBC still refused.(3121)

What gives ?

The reason I'm asking is due to the following extra information.

Other developers here have the same problems, attempting to use ODBC with e.g. ExCel.

We have tons of ODBC kits of 16 and 32 bits. From intersolv we got 32 bit Q&E Oracle driver (and the same problems).

We have 16bit windows machines running 16bit ODBC, and there it works ! And as far as we can tell, we are configuring the 16bit ones in the same way as the 32bit ones.

I am sick and tired of ORA-03121. This is not the first time I have spent terrible amounts of time fighting with this error, only to find out weeks later that it was due to some obscure obscurity.

(The typical 3121 problems I've experienced have been of the kind
"application A connects perfectly, and application B says 3121".

I've consulted various "3121 guides" I've found on the net
(some faq?), but they seemed to cover only stuff I was already aware
of, and don't think apply in this case
(the path, and superfluos versions of ora6win.dll, and what have you).

I hate this, especially since I'm not particularly fond of ODBC in the first place, because of performance issues.

--
Goddag mit navn er Gert Bo og jeg er en potens af 2.
Received on Fri Jul 26 1996 - 00:00:00 CEST

Original text of this message