1 Reply Latest reply on Oct 4, 2002 3:47 PM by 82532

    If I open a connection, how do I close it?

      Here is the way I connect:

      Sub EmpData()

      'Declare variables as objects
      Dim OraSession As Object
      Dim OraDatabase As Object
      Dim EmpDynaset As Object

      Dim flds() As Object
      Dim fldcount As Integer

      Set OraSession = CreateObject("OracleInProcServer.XOraSession")
      Set OraDatabase = OraSession.OpenDatabase("DEVDB", "scott/tiger", 0&)
      Set EmpDynaset = OraDatabase.CreateDynaset("select * from emp", 0&)

      Do I have to close the connection before I can connect again? If so, how? Thanks, Jeremy