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:
- Defining an ODBC Data Source with the ODBC Data Source Wizard
- Creating and Editing SAND Connection Definitions for an ODBC Client
- Setting Advanced ODBC Options
- Using an ODBC Connection String
ODBC Driver Data Type Conversions