Security

How secure is QuNect ODBC for QuickBase?

Please read QuNect Security

FAQ for QuNect ODBC for QuickBase

Versions

How do I tell what version of QuNect ODBC for QuickBase I have installed?

Start->Run...->odbcad32->Drivers (tab)->Version (column)

Compatablity

What version of ODBC does QuNect ODBC for QuickBase support?

ODBC version 3.0 is supported (Level 2 API)

What operating systems does QuNect ODBC for QuickBase support?

Windows XP Home and Professional, Windows 2000, Windows Vista, Windows Server 2003

What hardware does QuNect ODBC for QuickBase support?

All x86 based Intel processors and AMD x64 processors

In MS Access I can see my list of tables but I can't link to a table

Make sure you have the same application token installed in your QuickBase application and in your QuNect ODBC for QuickBase DSN. Please watch Getting Started

SQL Syntax

What characters are wildcard characters in a LIKE clause?

% (percent sign) means any number of characters and _ (underscore) means any single character.

What SQL JOINs does QuNect ODBC for QuickBase support?

INNER JOIN and LEFT OUTER JOIN but not RIGHT OUTER JOIN

What SQL grammar is supported?

minimum+ SQL grammar

How do I specify dates?

SELECT * FROM tablename WHERE datefield = {d '2008-04-25'}

How do I specify timestamps?

SELECT * FROM tablename WHERE timestampfield = {ts '2008-04-25 10:19:48.529'}

How do I specify time?

SELECT * FROM tablename WHERE timefield = {t '10:19:48'}

QuickBase Fields

Why do QuickBase user fields enclose names in double quotes?

Please read QuickBase User Field Behaviour