Nucleus ODBC Setup Guide for Windows Clients



The Nucleus ODBC Driver for Windows clients allows users of ODBC-enabled client programs running on Windows systems to connect to a SAND database instance. This page provides a step-by-step guide to setting up an ODBC data source definition (DSN) for a database using the SAND ODBC Data Source Wizard, and also contains information about setting other ODBC-related options and parameters.

The ODBC Data Source Wizard program creates or updates entries in the Windows registry, and may also make entries in the client-side nucleus.ini file (located in the SUPPORT directory as specified by the NUCLEUS environment variable).

The Nucleus ODBC Driver removes all square brackets characters ('[' and ']') from SQL strings passed to SAND CDBMS.

ODBC 32-bit vs 64-bit

The Nucleus ODBC Driver installation for 64-bit Windows includes both the 32-bit and 64-bit versions of the driver, so either can be used in a 64-bit environment. However, the SAND ODBC Data Source Wizard currently exists only in a 32-bit form, which means that it can only create 32-bit DSNs. In order to create a 64-bit SAND data source, the Windows 64-bit ODBC Data Source Administrator program must be used:

Control Panel> Administrative Tools> Data Sources (ODBC)

Note that the 64-bit ODBC Data Source Administrator can display only 64-bit DSNs. To view and manage existing 32-bit DSNs, the 32-bit version of the ODBC Data Source Administrator must be used:




see also
ODBC Driver Data Type Conversions