connection pool in ADO.NET

Discussion in 'ASP .Net' started by Grey, Apr 20, 2004.

  1. Grey

    Grey Guest

    is the connection pooling mechanism set default in the normal connection string, i.e.

    "Provider=SQLOLEDB;Server=SERVER_NAME;User ID=sa;Password=;Database=DB_NAME"

    If not, what is the difference if I use connection pool and not in user and programmer point of views??


    Million Thanks..
     
    Grey, Apr 20, 2004
    #1
    1. Advertising

  2. Connection pooling is the default for SQL Server. If you use the Sql Client
    the pooling key on the command line allows you to turn off pooling if you
    don't want it, but it's on by default. You can also set the size of the
    connection pool.

    With OleDb the pooling is handled by the Sql Server OleDb driver. I'm not
    sure if you can control pooling with the connection string or not, but it is
    enabled by default.

    +++ Rick ---

    --

    Rick Strahl
    West Wind Technologies
    http://www.west-wind.com/
    http://www.west-wind.com/weblog/
    ----------------------------------
    Making waves on the Web


    "Grey" <> wrote in message
    news:...
    is the connection pooling mechanism set default in the normal connection
    string, i.e.

    "Provider=SQLOLEDB;Server=SERVER_NAME;User ID=sa;Password=;Database=DB_NAME"

    If not, what is the difference if I use connection pool and not in user and
    programmer point of views??


    Million Thanks..
     
    Rick Strahl [MVP], Apr 20, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. nita
    Replies:
    1
    Views:
    905
    Saravana
    Nov 20, 2004
  2. ronaldlee

    Transfer ADO Code to ADO.NET

    ronaldlee, Dec 17, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    491
    Kevin Spencer
    Dec 17, 2004
  3. Replies:
    0
    Views:
    1,345
  4. Linus Nikander
    Replies:
    5
    Views:
    562
  5. Wei  Lu
    Replies:
    2
    Views:
    6,025
    Wei Lu
    Feb 16, 2009
Loading...

Share This Page