0 Replies Latest reply on Oct 9, 2002 9:21 AM by 243075

    Session Scope Connection Pool ???

    243075
      Hi

      I need to create a connection pool that a session scope.

      so I did this:

      in global.asa file ............................................................

      <OBJECT RUNAT=Server SCOPE=Session ID=gobjOraSession PROGID="OracleInProcServer.XOraSession"></OBJECT>


      after the user is prompted for username / password in an asp file .............
      ...
      ...
      on error resume next          
           
      ' create connection pool
      gobjOraSession.CreateDatabasePool 1, 100, 60, "xxx", "please/work", 0

      if err.number <> 0 then
                
           ' return xml in response object
           objXmlDoc.loadXML("<error>" & err.Description & "</error>")
           objXmlDoc.Save(Response)
                     
           ' destroy session
           gobjOraSession.destroyDatabasePool

      else

           ' return xml in response object
           objXmlDoc.loadXML("<success>Logon Successful</success>")
           objXmlDoc.Save(Response)

      end if
      ...
      ...



      This all works great, BUT when I try to use retrieve a connection from the pool
      later on in bombs out. I would have created the conn pool in global.asa file but
      I cant as i dont have the users credentials yet

      PLEASE help...

      Thanks