1 Reply Latest reply on Mar 25, 2003 6:52 PM by 387958

    Problem in Creation of Oracle Session in Global.asa

    169455
      Dear all,

      I tried to run an ASP example on OO4O and created the following global.asa.

      <OBJECT RUNAT=Server SCOPE=Application ID=OraSession
      PROGID="OracleInProcServer.XOraSession"></OBJECT>
      <SCRIPT LANGUAGE=VBScript RUNAT=Server>

      Sub Application_OnStart

      'Get an instance of the Connection Pooling object and create a pool
      of OraDatabase
      OraSession.CreateDatabasePool 20,40,200,"XXX", "xxx/xxx", 0

      End Sub

      Sub Application_OnEnd

      OraSession.destroyDatabasePool

      End Sub


      </SCRIPT>

      However, the IIS reported the following error when running.
      "An error occurred while creating object 'OraSession'".

      I have used the same connection string on a VB project. The connection works perfectly. Could anyone know why the connection cannot setup on ASP?

      Thank you very much

      Samuel