Application Note for QuNect ODBC for QuickBase

Creating a Connection String

A ODBC connection string tells the ODBC driver manager which ODBC driver to use and also contains various parameters that the ODBC driver manager passes down to the ODBC driver itself. The following configurator will walk you through all the options available for the QuNect ODBC for QuickBase ODBC driver.

Please enter the QuickBase Server name you type into the URL that you use to access QuickBase in your browser. This would be something like mycompany.quickbase.com.  Please watch this getting started video to learn more about the QuickBase Server property.
Use a DSN-less connection
Use a DSN
The first decision you have to make in creating a connection string is whether or not to use a DSN. A DSN (Data Source Name) is a configuration for an ODBC driver that is stored in the registry. When you install QuNect ODBC for QuickBase a DSNs are created that start with QuickBase via QuNect. However the DSNs do not have a username, password or proper QuickBase Server associated with them until you configure them. Please read the Getting Started application note or  watch this getting started video to learn how to configure your DSNs. After installation you can create your own additional DSNs and give them any name you wish.
Do not specify a username
Specify a username
If you've specifed a DSN above then you don't have to specify a username here and the username saved in the DSN will be used. You can specify a username here while using a DSN and the username you specify here will take precedence over the one saved in the DSN. Usernames are either the email address you signed up to QuickBase with or a QuickBase screen name.
Do not specify a password or user token
Specify a password or user token
If you've specifed a DSN above then you don't have to specify a password or user token here and the password or user token saved in the DSN will be used. You can specify a password or user token here while using a DSN and the password or user token you specify here will take precedence over the one saved in the DSN.
Use the default application token
Use your application token
By default applications require application tokens. However application tokens can be turned off on an QuickBase application by QuickBase application basis. If your QuickBase application requires application tokens then you may want to specify your own. Otherwise QuNect ODBC will use its own
b2fr52jcykx3tnbwj8s74b8ed55b
Please read the QuickBase help on Application Tokens and  watch this getting started video to learn more about the application tokens.
Do not try to connect through a proxy server
Find a proxy server and connect through the proxy server
In some local area networks you need to connect through a proxy server to get to QuickBase. If this is the case then you'll need to put this on the connection string. With MS Windows, if DETECTPROXY=1, and there is no proxy server QuNect ODBC for QuickBase will still successfully connect but with an initial delay of a quarter of a minute. On Linux, if DETECTPROXY=1, and there is no https_proxy environment variable, QuNect ODBC for QuickBase will return an error.
I want to use field names
I want to use fids
Every QuickBase field has both a name and field identifier (fid). Field names can be changed by an administrator. Fids cannot be changed. Once a field is created it always has the same fid. Within a table a fid is unique and if a field is deleted its fid is never reused. So if you want to prevent the changing of field names from effecting your SQL statements then you should set this option to use fids.
Empty text fields are not null
Empty text fields are null
QuickBase does not distinguish between an initially empty text field and a text field that used to contain text and no longer does. Another way to say this is that there is no such concept as a NULL value for text fields in QuickBase. So the default behaviour for QuNect ODBC for QuickBase is to never report text fields as having a NULL value. However you can force QuNect ODBC for QuickBase to report empty text fields as NULL.
Leave numeric values unchanged when inserting or updating percent fields.
Multiply numeric values by 100 when inserting or updating percent fields.
QuickBase does not distinguish between an initially empty text field and a text field that used to contain text and no longer does. Another way to say this is that there is no such concept as a NULL value for text fields in QuickBase. So the default behaviour for QuNect ODBC for QuickBase is to never report text fields as having a NULL value. However you can force QuNect ODBC for QuickBase to report empty text fields as NULL.
User fields are email addresses or screennames
User fields are invariant user identifiers (uids)
Useful if you want to be able to keep track if QuickBase users even when they change their email address or screennames. You can always get the email address or screenname from a formula text field that has this formula: ToText([User field name]). But there is no QuickBase formula that will give you a user field's uid value.
Text File Attachment fields
Binary File Attachment fields
Download File Attachments to disc
By default QuNect ODBC for QuickBase presents QuickBase file attachment fields as a text field containing a URL to the attached file. If you set this field to a fully qualified path on your local computer (e.g. c:\projects\inprogress\stage1.mpp), QuNect ODBC for QuickBase will upload that file from your harddrive to QuickBase. But you can change this behaviour to make QuNect ODBC for QuickBase present file attachment fields as binary fields. This is particularly useful with SQL Server. In SQL Server binary fields are of type picture. You have another option instead of the binary field type you can specify a path to a local disc and QuNect ODBC for QuickBase will download attachments to that folder. Please read the application note entitled Downloading File Attachments from QuickBase into SQL Server for more information.
Download only the current revision of file attachment fields
Download all revisions of file attachment fields
Only matters if you've chosen to specify that you want file attachments downloaded using the connection string option above.
Generate an error if uploading a file that does not exist
Ignore and continue when encountering missing files for upload
QuNect ODBC for QuickBase will upload a local file to a file attachment field if you set the file attachment field's value to the path of a file on local disk. If the file does not exist an error is generated by default. If you use this connection string parameter you can ignore these errors when processing multiple records.
Use the default duration of days on input and milliseconds on output
Use a single specific duration on input and output
Duration fields (a numeric field) present the number of milliSeconds. And when updated or inserted the supplied number is interpreted as days. However if the DURATION parameter is set to either:
  • sec
  • min
  • hour
  • day
  • week
Both inputs and outputs to the numeric duration fields will be interpreted in those units.
Use the default set of characters for field names
Specify the set of characters for field names
QuickBase allows a far wider range of characters in field names and table names than most other database systems. Here you can specify which characters QuNect ODBC for QuickBase allows in field names and table names. Characters that are not allowed are replaced with the underscore character. This setting does not impact field names and table names appearing in MS Access tables linked with QuNect ODBC for QuickBase.
Do not specify temp directory
Specify temp directory
QuNect ODBC for QuickBase uses temporary files to perform sorting operations that QuickBase cannot handle. This setting allows you to specify the directory where these temporary files will be created. You can leave this setting blank and QuNect ODBC for QuickBase will ask the operating system to designate a temporary directory.
Do not use table aliases
Use table aliases
Please read the application note on table aliases for more information.
Do not log SQL statements.
Log SQL statements to a file on my computer.
Logging of SQL statements goes to the file C:\windows\temp\qdbODBC.log on computers running MS Windows. Otherwise the log file is /tmp/qdbODBC.log
Do not log API calls.
Log API calls to a file on my computer.
Logging of SQL statements goes to the file C:\windows\temp\qdbODBC.log on computers running MS Windows. Otherwise the log file is /tmp/qdbODBC.log
Use credentials in DSN
Use credentials in connection string
Some applications like Tableau Server will specify a connection string with a DSN parameter yet they will also specify UID and PWD parameters in the connection string. Normally the UID parameter (QuickBase username) and PWD (QuickBase password) parameters in the connection string supercede the QuickBase username and password settings in the DSN. This parameter allows you to force QuNect to use the UID and PWD from the DSN even if these parameters exist in the connection string.
Upload all records to QuickBase in one operation
Limit size of records uploaded to QuickBase
The number of bytes you want to limit the CSV import size to. You'll need make sure that you set this high enough so that it's greater than the largest number of bytes in a single record.
Let QuNect ODBC for QuickBase ask the Windows operating system for the proxy server configuration.
Specify the proxy server information in the connection string.

This parameter only applies to QuNect ODBC for QuickBase running on the Microsoft Windows operating systems.

You will need to specify this as the proxy server hostname followed by a colon and then the port number.
Use default timeouts
Specify custom timeouts

This parameter only applies to QuNect ODBC for QuickBase running on the Microsoft Windows operating systems.

Resolve timeout milliseconds
An integer that specifies the time-out value, in milliseconds, to use for name resolution. If resolution takes longer than this time-out value, the action is canceled. Zero, the default value, means no time-out (infinite).

Connect timeout milliseconds
An integer that specifies the time-out value, in milliseconds, to use for server connection requests. If a connection request takes longer than this time-out value, the request is canceled. The default value is 370,000 (6 minutes and 10 seconds).

Send timeout milliseconds
A value of type integer that specifies the time-out value, in milliseconds, to use for sending requests. If sending a request takes longer than this time-out value, the send is canceled. The default is 370,000 (6 minutes and 10 seconds).

Receive timeout milliseconds
A value of type integer that specifies the time-out value, in milliseconds, to receive a response to a request. If a response takes longer than this time-out value, the request is canceled. The default value is 370,000 (6 minutes and 10 seconds).