As you most likely already know, Oracle7 Server version 7.3 supports SQL*Net Version
2 only. Version 1 is not supported.
Furthermore, SQL*Net Version 2 error messages are of the form TNS-12xxx or TNS-xxxx.
If memory serves me, ORA-3121 is a SQL*Net verson 1 error message which in your case
means your PC setup needs help (this is news to you, right?).
It seems that *at least* the path has been screwed up whenever we got an ORA-3121.
Solving way I've solved these kinds of connection problems is to verify that each
layer of the stack works.
First thing to do is verify that the client PC has Oracle set up properly. Try the
following from a *DOS* window. cd to "c:\orant\bin" and run tnsping <service_name>
[<count>]. In my case, I would try "tnsping spinner.sjtc.whirlpool.com". If this
works ok, then verify the path by trying it again from some directory other than
\orant\bin. The next course you pursue depends on these results.
The above assumes 32-bit SQL*Net. (For 16-bit use substitute c:\orawin\bin and note
that 16-bit tnsping is a windows not dos pgm.)
Good luck,
Al Malin
[EMAIL PROTECTED] wrote:
> Does anyone have a specific driver for Oracle?
>
> I need the ora73win.dll driver.
>
> Here is my situation:
>
> - 2 PB4 Apps
> - Windows NT
> - Oracle 7.3
> - SQL*NET 2.3
>
> I cannot connect to Oracle through PB. Whenever I type in OR7 for the DBMS,
> I get a ORA-3121 error. If I change this to O73 for the DBMS, I get a
> message saying it cannot find ora73win.dll. We are NOT using ODBC, we are
> using a native connection. We have read where this is possible to do.
>
> We had been running with Oracle 7.0 under windows 3.1 and SQL*NET 1.0 (I
> think). The Y2K thing has the network guy moving to NT. This has
> precipitated us to upgrade the Oracle.
>
> TIA,
>
> M Roberts
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
