Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Lightbulb Unanswered: Optimal ADO Connections in one App

    Hi people,

    I'm using ADO to connect my application to an MS Access Database (2000).
    I remember reading somewhere that it's not a good idea to have a lot of connections to your DB. How do i make sure that only one connection is open at any given time. I do make a number of different connections to my db, some that update and some that simply query my tables.

    Thanks all for the help.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    How many concurrent clients will be using your application ? What driver are you using in your connection string ?

Posting Permissions

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