Database drivers

You must install and configure database drivers and at least one driver manager before you can use the ODBC connector.

Supported drivers are included with the installation of the product. The default installation directory is install_home/Server/branded_odbc. The DataDirect Connect for ODBC for SQL Server Legacy Wire Protocol driver (VMmsss00.so and VMmsss00.dll) is now deprecated. Use the DataDirect Connect for ODBC for SQL Server Wire Protocol driver (VMsqls00.so and VMsqls00.dll) instead.

The following drivers have limitations or special configuration requirements when you use them with the ODBC connector:
IBM® Text File Driver
  • Supported data types. Only Numeric, Date, and VarChar are supported.
  • Unsupported runtime data types. The following runtime data types are not supported:
    • Bit
    • Binary
    • LongNVarChar
    • LongVarBinary
    • LongVarChar
    • NChar
    • NVarChar
    • Time
    • Timestamp
SQL Server driver
  • Large objects (LOBs) by reference. You cannot pass them by reference with this driver. You must transfer them inline.
SQL Server native driver
  • Transfer large objects (LOBs) by reference. You cannot pass them by reference with this driver. You must transfer them inline.
SQL Server wire driver
  • Transfer large objects (LOBs) by reference. You cannot pass them by reference with this driver. You must transfer them inline.
  • View design-time data. To view design-time data that contains spaces, you must select the quoted identifiers check box on the Advanced tab of the driver setup window.