Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 17 OCT 1997 03:37:40PM Cameron Revelation wrote:

Bengt,

]] how .. do I make OI understand that I want to connect to an

]] Oracle DB using sqlnet v 2 ???

]] I'm using Oracle 7.3 .. plus32 worx just fine ..

I have set up Oracle 7.3 (Workgroup Server on NT) with SQL*Net v2 (2.3.3). I can successfully use it from OI.

]] but I don't know how to configure the XO ..

]] most of the fields in the configuration box are not relevant, as I

]] see it .. one field would be enough .. describing the

]] symbolic name of the sqlnet v 2 link …)

You are correct. Specify the symbolic Oracle name (as registered using the "SQL Net Easy Configuration" tool that comes with Oracle) for the "HostString" value.

]] I have tried .. but I get the error 0RA-03121)

I got the same exact error – "ORA-03121: No interface driver connection - function not performed". That means that OI can't find your Oracle DLL's probably. Add the Oracle .\bin to your path. For example, mine is under:

"c:\Program Files\OraWin\Bin"

So my path includes:

set path=c:\windows;c:\windows\system;c:\progra~1\orawin\bin

]] why doesn't OI detect my installed 7.3 Oracle ??? though

]] it's in the 'path' …

Hmm … that is odd. What version of OI? Starting with 3.3 or 3.4 it auto-configures itself to find the latest Oracle API.

Cameron. Revelation


At 25 OCT 1997 09:17AM bwk wrote:

OK Cam …

my version is 3.2 but upgraded with the new Oracle DLLs and

the SYSOBJ code that was supposed to be the ones that OI use

for Oracle access …

anyway .. I give in about keeping 3.2, and will try the SQLNET*2

connection when I have the 3.4 version …

/Bengt


At 26 OCT 1997 04:16PM Cameron Revelation wrote:

Bengt,

Thanks! Specifically, I am curious if the problem had something to do with the 2.2 version of SQL Net. I am using 2.3.3 in house without a hitch.

Cameron. Revelation

View this thread on the forum...

  • third_party_content/community/commentary/forums_nonworks/9f4b1f0308803ab585256533006bd195.txt
  • Last modified: 2023/12/28 07:40
  • by 127.0.0.1