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

    Unanswered: Multiple connections to Access via ODBC

    Im writing an application with a Delphi v5 frontend and Access for the Backend. Im connecting to Access using an ODBC link.

    The link works fine for 1 connection and fine for 2 connections, but if i try to connect more than twice i get a ODBC connection error.

    Is there a known limit to the number of connections you can have via ODBC or should i be looking at another area to solve the problem?????

  2. #2
    Join Date
    Sep 2003
    Shouldn't this be in a Delphi forum??? As for ODBC, you can have numerous connections open ... Access allows for a MAX of 255 concurrent connections.
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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