1 Reply Latest reply on Feb 17, 2006 5:46 PM by 82532

    How does one connect to an Oracle Database using OO4O as sysdba using VB 6?

    147888
      Hi,

      Can any one give suggestion to connect an Oracle Database using OO4O as sysdba using VB 6.0. Generally it supports only database, userid/password only.

      For Eg:

      Option Explicit

      Dim m_oraSession As Object
      Dim m_oraDatabase As Object

      Private Sub Command1_Click()
      Set m_oraSession = CreateObject("OracleInProcServer.XOraSession")
      Set m_oraDatabase = m_oraSession.DBOpenDatabase("Database", "user/password", 0&)

      MsgBox "Connected to " & m_oraDatabase.Connect & "@" & m_oraDatabase.DatabaseName
      End Sub

      Private Sub Form_Unload(Cancel As Integer)
      Set m_oraDatabase = Nothing
      Set m_oraSession = Nothing
      End Sub

      Thanks & Regards,
      Kishore.P
      E-Mail: kishore_pen@yahaoo.com