Application Note for QuNect ODBC for QuickBase

Minimizing API calls with QuNect ODBC for QuickBase

QuNect ODBC for QuickBase communicates with QuickBase exclusively through the QuickBase HTTP API. On some QuickBase plans there is a monthly limit on the number of API calls that can be made. QuNect ODBC for QuickBase 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 QuickBase 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 QuickBase.

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 QuickBase 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.