Get Data Moving 1
Results 1 to 3 of 3

Thread: ADO .NET Connection Pooling

  1. #1
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    ADO .NET Connection Pooling

    HOW TO: Enable Connection Pooling using Attunity ADO .NET v4.8.2

    DESCRIPTION

    The latest Attunity ADO .NET Client (v4.8.2) does not include the MMC of the previous version, and the concept of Configured Connection.

    In this version Connection Pooling is managed by ADO .NET similar to any other Microsoft ADO .NET provider.

    The topic is fully documented in the Help files, and Microsoft's documentation.

    EXAMPLES

    1. Create a new connection to DB2CLI on the Mainframe, with initial pool of 2 and maximum of 6 connections in the pool:-
    connString = "Server=myMVS;Port=2551;" +
    "Database=myDB2CLI;" +
    "Min Pool Size=2;" +
    "Max Pool Size=6";
    conn = New Attunity.Data.AisClient.AisConnection
    conn.ConnectionString = connString
    2. The connection pooling in ADO .NET is ENABLEd by default. In those situations where you have to disable the connection pooling, set the property "Pooling" to false:-
    connString = "Server=myMVS;Port=2551;" +
    "Database=myDB2CLI;" +
    "Pooling=false";
    Last edited by Admin_attu; 10-19-2006 at 05:43 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Betty Sullivan is offline Junior Member
    Join Date
    Sep 2006
    Posts
    12
    Rep Power
    0

    ADO .NET version 5.0

    Will the 5.0 version handle pooling the same way as 4.8.2 ?

  3. #3
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    ADO .NET Connection Pooling

    Yes, the connection pooling is on the client side, and nothing has changed in the .NET Data Provider
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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