OO4O 2.1 Connection using SQL*Net 2.x or Net8 ?

From: Richard D Holowczak <holowcza_at_andromeda.rutgers.edu>
Date: 15 Sep 1998 08:51:56 -0400
Message-ID: <6tlntc$bd8$1_at_andromeda.rutgers.edu>

Folks:
I am working on a Visual Basic 4.0 (32 bit mode) application with Oracle Objects for OLE (OO4O) version 2.1. The database is Oracle 8 and I have bother SLQ*Net 2.3 and Net8 installed on the client.

[Quoted] What should the "DatabaseName$" be set to in order to connect using SQL*Net 2.3 ? I am trying the simple "Login" example that comes with OO4O:

Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.DbOpenDatabase(DatabaseName$, Connect$, 0&)

Using any of the SQL*Net connect strings I have configured produces an ORA-12222 error saying TNS could not resolve the service name.

SQL*Plus 3.1 and SQL*Plus 8.0 both connect just fine using the same service names.

Thanks for any pointers.

Rich H.
Rutgers U. Received on Tue Sep 15 1998 - 14:51:56 CEST

This message: [ Message body ]
Next message: godzilla: "Re: Help PL/SQL (Table Datatype.)"
Previous message: John Oliver: "Re: Oracle Reports 2.5 - Date Formats."
Next in thread: Mark Wagoner: "Re: OO4O 2.1 Connection using SQL*Net 2.x or Net8 ?"
Reply: Mark Wagoner: "Re: OO4O 2.1 Connection using SQL*Net 2.x or Net8 ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message