QuNect ODBC for QuickBase on Mac OSX (Intel)

QuNect ODBC for QuickBase® is the world's first ODBC driver for Intuit's® QuickBase®.

QuNect ODBC for QuickBase allows you to access your data stored in QuickBase directly from many Macintosh applications. It works with the built-in iODBC driver manager.

Download Free Fully Functional 30 Day Trial

for 64 bit MacOSX Intel version 10.5 or higher.

Installation Instructions

Please download the file libqunect64.so by clicking on the download button above. Place the libqunect64.so in /Library/ODBC.

Go to your Applications folder and open the Utilities folder. Then double click on the ODBC Administrator application to open it up. If you can't find this application you'll have to install it. The ODBC Admin Tool is available from Apple. If you use Microsoft Excel then you'll also want to install the iODBC Driver Manager which is available from iODBC.org. Remember that MS Office applications before the 2016 version are all 32 bit applications and will not work with QuNect ODBC for QuickBase. Use the Apple provided ODBC Administrator application to create and configure your DSNs. Do not use the iODBC Driver Manager to edit your DSNs.

Configure the 64 bit driver

Then install the 64 bit driver. Use the Apple provided ODBC Administrator application to create and configure your DSNs. Do not use the iODBC Driver Manager to edit your DSNs. At the top of the Apple provided ODBC Administrator application click on Drivers. Then click on the Add... button. In the text box Description type QuNect ODBC for QuickBase 64 bit. To the right of the Driver file: text box click on the Choose... button and find libqunect64.so which should be residing in /Library/ODBC as you were instructed above to install it. You'll need to navigate to your built-in hard drive, often named Macintosh HD. Then Click on the Apply button to save your changes.

Create a 64 bit DSN

Click on the User DSN tab at the top of the ODBC Administrator application. System DSNs do not work properly with ODBC drivers that require more than a username and password. Then click the Add... button and choose the QuNect ODBC for QuickBase 64 bit driver. Give the DSN a name of QuickBaseViaQuNect64. Click the Add button. A new row appears in the table with the words Key and Value. Click Key once and hit the enter key to edit it. Type in UID, and press Enter. Click Value once and hit the enter key to edit it. Type in the email address or screenname of the QuickBase user that will be used to connect. Click on the Apply button to save your changes.

Now you need to specify the QuickBase password for this user. Click the Add button. A new row appears in the table with the words Key and Value. Click Key once and hit the enter key to edit it. Type in PWD, and press Enter. Click Value once and hit the enter key to edit it. Type in the QuickBase password for the user that will be used to connect. Click on the Apply button to save your changes.

Click the Add button. A new row appears in the table with the words Key and Value. Click Key once and hit the enter key to edit it. Type in QUICKBASESERVER, and press Enter. Click Value once and hit the enter key to edit it. Type in your unique URL: mycompany.quickbase.com.

Application Tokens

If you have application tokens turned on in your QuickBase applications, (which is the default) then you will need to add another key and value pair. Click the Add button. A new row appears in the table with the words Key and Value. Click Key once and hit the enter key to edit it. Type in APPTOKEN, and press Enter. Click Value once and hit the enter key to edit it. Type in your application token.

QuNect ODBC for QuickBase comes preconfigured with its own application token. The QuNect application token is

b2fr52jcykx3tnbwj8s74b8ed55b

You can use this predefined QuNect application token by reading the instructions on how to use an existing application token. Using this predefined application token is not as secure as creating your own application token and entering it here. Please read the section entitled Create and assign an application token on the QuickBase help page entitled Application Tokens. Click on the Apply button to save your changes.

Advanced users may want to add additional key-value pairs. You can discover the meaning of additional key and value pairs by reading the application note on QuNect ODBC for QuickBase connection strings.

Microsoft Query as part of Microsoft Excel 2011 requires a unique format for Date and DateTime criteria. Date criteria need to be entered like this:

<= {d '2014-12-17'}

DateTime criteria need to be entered like this:

You can safely dismiss MS Query popup dialogs like this that complain about the value type.

>= {ts '2014-12-17 17:59:59.000'}