Re: Connecting to Oracle using OracleInProcServer

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 9 May 2006 22:06:27 +0200
Message-ID: <4460f644$0$32031$636a55ce_at_news.free.fr>


<ggodik_at_gmail.com> a écrit dans le message de news: 1147204421.945291.112430_at_v46g2000cwv.googlegroups.com...
| Hello all
|
| I'm trying to connect to an oracle 9i database from VBA using an
| OracleInProcServer.XOraSession object.
|
| numerous tutorials give the following
|
| Set OraSession = Server.CreateObject("OracleInProcServer.XOraSession")
| Set OraDatabase = OraSession.DbOpenDatabase("", "scott/tiger",cint(0))
| or
| Set OraSession = CreateObject("OracleInProcServer.XOraSession")
| Set OraDatabase = OraSession.DbOpenDatabase("SQL*Net_Connect_String",
| "scott/tiger", 0)
| or
| Set oSession = CreateObject("OracleInProcServer.XOraSession")
| userPass = "SYSTEM/MANAGER"
| Set oDb = oSession.OpenDatabase("VENKAT16", userPass, 1)
|
| where does the 1st parameter come from ?
| in the documentation its called databse. what is this supposed to match?

An entry in your tnsnames.ora or "" for a local connection assuming ORACLE_SID is set.

Regards
Michel Cadot

| a. server address
| b. some sort of predefined DSN ?
|
| If anyone has any1 input on this, please help out.
|
Received on Tue May 09 2006 - 22:06:27 CEST

Original text of this message