How does one connect to an Oracle Database?
Submitted by admin on Wed, 2005-11-09 23:38.
Connect to Oracle using the OpenDatabase function. The OpenDatabase function
returns an OraDatabase object. Parameters are DB_NAME, CONNECT_DESCRIPTOR and
CONNECT_OPTIONS. Look at the following Visual Basic code example:
Dim OraSession As Object 'Declare variables as OLE Objects
Dim OraDatabase As Object
Dim OraDynaset As Object
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("SQL*Net_Connect_String", "scott/tiger", 0&)
MsgBox "Connected to " & OraDatabase.Connect & "@" & OraDatabase.DatabaseName
MsgBox "OO4O Version: " & OraSession.OIPVersionNumber
MsgBox "Oracle Version: " & OraDatabase.RDBMSVersion»
- Login to post comments

