How to Reuse Connection Pool to Database from eScript Using ADODB (Doc ID 1984319.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Goal

Customer has a development which consists in invoking a database procedure from escript and using an ODBC configured in the server machine, via ADODB. It works fine but we have realized that when a database connection is opened, it is closed inmediately, so connections are being opened and closed constantly, and they do not remains opened during a time, so they can not be reused. We think it could be affecting to the performance and we would like to mantain the database connections opened in order to reused them.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms