Application Note for QuNect ODBC for Quick Base
Minimizing API calls with QuNect ODBC for Quick Base
QuNect ODBC for Quick Base communicates with Quick Base exclusively through the Quick Base HTTP API. On some Quick Base plans there is a monthly limit on the number of API calls that can be made. QuNect ODBC for Quick Base caches table schema information on a ODBC connection basis to minimize API calls. However sometimes the user doesn't have control of when an ODBC connection is dropped. Dropping an ODBC connection means that QuNect ODBC for Quick Base loses its table schema caches. However the Microsoft Windows operating systems support ODBC connection pooling to solve this problem. Go to the ODBC administrator panel. Click on the Start Menu and click on the All Programs then on QuNect ODBC for Quick Base.
Then click on 32 bit ODBC Admin or 64 bit ODBC Admin depending on whether you are using a 32 bit or 64 bit application. If in doubt do both.
You'll end up at the dialog below:
Click on the Connection Pooling tab. You'll see the dialog below:
Double click on QuNect ODBC for Quick Base and select Pool connections to this driver. Enter the number of seconds that you anticipate will lapse between your API calls. Click OK and then OK again.