Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: How can we check Connection Pooling in VB is enabled or not?


    I am trying to use Connection Pooling in Visual Basic.
    Firstly, I am not been able to get the required functions i.e. SQLConnect, SQlDissconnect etc., which are required to do the Connection Pooling.

    Secondly, How can I check connection pooling is working or not in Visual Basic?

    Please reply if u have any idea about this.
    Thanks in Advance...


  2. #2
    Join Date
    Nov 2004
    It seems that you are trying to re invent the wheel

    ole db and odbc already take care of that eficiently

    you just have to remember to connect (conn.Open connStr) as late as you can and to disconnect(conn.close and set conn = Nothing) as soon as you can and do not keep connection when it is not necesary.
    to err is human ; to really mess things up requires a computer

Posting Permissions

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