Connecting to Oracle using OracleInProcServer
Date: 9 May 2006 12:53:42 -0700
Message-ID: <1147204421.945291.112430_at_v46g2000cwv.googlegroups.com>
[Quoted] 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
?
a. server address
[Quoted] b. some sort of predefined DSN ?
If anyone has any1 input on this, please help out. Received on Tue May 09 2006 - 21:53:42 CEST