Attn Bengt @ Akribi: SQL*Net v2 (OpenInsight Specific)
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