ODBC application development

Every C/C++ source file that calls ODBC functions must include a platform-specific ODBC header file. Each platform-specific header file includes the main ODBC header file odbc.h, which defines all the functions, data types, and constant definitions required to write an ODBC program.

Perform the following tasks to include the ODBC header file in a C/C++ source file:

1. Add an include line referencing the appropriate platform-specific header file to your source file. The lines to use are as follows:

   Operating system	Include line
   Windows	#include "ntodbc.h"
   Unix	#include "unixodbc.h"
   Windows Mobile	#include "ntodbc.h"

2. Add the directory containing the header file to the include path for your compiler.

   Both the platform-specific header files and odbc.h are installed in the SDK\Include subdirectory of your SAP Sybase IQ installation directory.

3. When building ODBC applications for Unix, you might have to define the macro "UNIX" for 32-bit applications or "UNIX64" for 64-bit applications to obtain the correct data alignment and sizes. This step is not required if you are using one of the following supported compilers:

   • GNU C/C++ compiler on any supported platform
   • Intel C/C++ compiler for Linux (icc)
   • SunPro C/C++ compiler for Linux or Solaris
   • VisualAge C/C++ compiler for AIX
   • C/C++ compiler (cc/aCC) for HP-UX

Once your source code has been written, you are ready to compile and link the application. The following sections describe how to create executable applications.

• ODBC Applications on Windows
  When linking your application, you must link against the appropriate import library file to have access to the ODBC functions.
• ODBC applications on Unix
  An ODBC driver manager for Unix is included with SAP Sybase IQ and there are third party driver managers available. This section describes how to build ODBC applications that do not use an ODBC driver manager.
• The unixODBC driver manager
  Versions of the unixODBC release before version 2.2.14 have incorrectly implemented some aspects of the 64-bit ODBC specification as defined by Microsoft. These differences will cause problems when using the unixODBC driver manager with the SAP Sybase IQ 64-bit ODBC driver.
• UTF-32 ODBC driver managers for Unix
  Versions of ODBC driver managers that define SQLWCHAR as 32-bit (UTF-32) quantities cannot be used with the SAP Sybase IQ ODBC driver that supports wide calls since this driver is built for 16-bit SQLWCHAR. For these cases, an ANSI-only version of the SAP Sybase IQ ODBC driver is provided. This version of the ODBC driver does not support the wide call interface (for example, SQLConnectW).