vasupcorp.blogg.se - Informix odbc 64-bit driver

#INFORMIX ODBC 64 BIT DRIVER INSTALL#
#INFORMIX ODBC 64 BIT DRIVER DRIVERS#

To work around this problem, install a hybrid driver (pre-4.10 version).

You can submit SQL procedure code that references this libref, but Informix character data values are read in as missing values.

You cannot successfully submit DATA step code that references this libref.

You can assign a SAS/ACCESS Interface to Informix LIBNAME statement, but DATASETS procedure code that references this libref does not yield a complete list of tables.

However, if you use the Informix version 4.10 driver, then you might encounter the following problems:

In SAS releases earlier than SAS 9.4 TS1M3, SAS/ACCESS Interface to Informix expects that a hybrid Informix driver is used. See the Output tab for content relevant to this scenario. Problem Scenario 1: SAS 9.3 TS1M2 with Informix 4.10 With SAS 9.4 TS1M2 and earlier versions of SAS, SAS/ACCESS Interface to Informix works with Informix versions prior to version 4.10.ĭue to this change in the Informix ODBC driver, it is possible that problems will occur. Beginning with SAS ® 9.4 TS1M3, the baseline version of the IBM Informix driver that SAS supports with SAS/ACCESS Interface to Informix is version 4.10. Accordingly, SAS/ACCESS Interface to Informix now accommodates this new generation of drivers.

#INFORMIX ODBC 64 BIT DRIVER DRIVERS#

Therefore, the drivers are no longer considered hybrids. With version 4.10, IBM began providing Informix ODBC drivers that are more in line with current ODBC specifications.

SAS/ACCESS Interface to Informix relies on this driver and was originally engineered to accommodate these hybrid Informix ODBC drivers. Prior to version 4.10, the Informix ODBC driver provided by IBM for UNIX platforms was a "hybrid," which means that it was built on an older ODBC model using 32-bit data types.