Previous Topic

Next Topic

Book Contents

Configuring an ODBC connection

To configure ODBC connection pooling by changing the Timeout value to provide a longer connection time:

  1. Select Start > Programs > Administrative Tools > Data Sources.

    The ODBC Data Source Administrator window appears.

  2. Select the Connection Pooling tab.
  3. Double-click Oracle in <ORACLE_HOME>

    where <ORACLE_HOME> is your Oracle Client Home.

    The Set Connection Pooling Attributes dialog box appears.

  4. Make sure that the Pool connections to this driver radio button is selected and that the value is moderately long (about 450 seconds*). If it is too short, the connection will constantly be refreshing itself; if it is too long, the connection will consume too many resources.

    The recommended Pooling Timeout = 1.5 x MSDTC Timeout Value

  5. Click OK, and then OK again to close the ODBC Data Source Administrator.
Send Feedback