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

On 15 Sep 1998 08:51:56 -0400, holowcza_at_andromeda.rutgers.edu (Richard D Holowczak) wrote:

>
>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.

It should be the same as the database alias used in SQL*Plus.

Just as a long shot, check to make sure the [ORACLE_HOME]\Bin directory is on your path. I have seen many instances where the installer did not update the autoexec.bat file properly under 95.

If it is, maybe Net8 is messing with it. You could possibly try a newer version of OO4O. Mine is 2.2.3.

HTH

--
Mark Wagoner
To reply, remove no.spam from my e-mail address