For SAS/ACCESS Interface to Informix, SAS^®9 uses the Informix ODBC Driver API to connect to Informix, and the connection options have been changed accordingly. The DATABASE option from SAS/ACCESS in SAS^® 8 has been removed.

If you need to specify a database, set it in the odbc.ini file. For SERVER options, instead of specifying the server name as in SAS 8, specify an ODBC data source name. Optionally, you can use a user ID and password in conjunction with the SERVER= option.

In your odbc.ini file, the DATASOURCE name is the name that is found in the square brackets before all the details and the definition of the server/database.

Here is an example of an odbc.ini file used with SAS/ACCESS Interface to Informix with SAS 9:

For example, in SAS^® 8.2, the LIBNAME or PROC SQL Passthru code looked similar to one of the following:

• libname x user=dbuser password=dbpwd db=stores server=warehouse;
• proc sql; connect to informix (user=dbuser password=dbpwd db=stores server=warehouse);

Therefore, in SAS 9, your odbc.ini file should look similar to the following:

With SAS 9, the LIBNAME or PROC SQL Passthru code looks similar to the following:

In some cases, the odbc.ini file is stored under $INFORMIXDIR/etc for public usage. However, an odbc.ini file can be stored under the WORK directory and the ODBCINI environment variable can point to it, as follows:

Operating System and Release Information