Access Oracle DB through ASP

Results 1 to 2 of 2

Thread: Access Oracle DB through ASP

  1. #1
    Join Date
    Dec 1969

    Default Access Oracle DB through ASP

    Hi, we are having a question here. We are developing an intranet web based system that will access oracle db. The problem is that when our client access our system, when the page contains any connection to oracle db, one user session will be created in oracle. Imagine if there are ten sql to be executed in one single page, there will be ten user session created.<BR><BR>We have used the recordset.close method but the user session is still not terminated. Is there any other method in ADO object that will terminate the user session created in oracle db?<BR><BR>Thankz...

  2. #2
    Join Date
    Dec 1969

    Default Connection Pooling?

    I think connection pooling may be keeping the connection open so it can be re-used by another user, this helps performance as a new connection doesn&#039;t have to be re-established everytime, you can switch this off in the ODBC settings.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts