ODBC Drivers

Overview

SAS Federation Server 3.2 is installed with release 7.1 of the ODBC drivers. The installation directory for Windows has changed to C:\Program Files(x86)\DataFlux\ODBC\7.1. All of the existing ODBC DSNs should use the new 7.1 ODBC drivers and modifications are not necessary. If you are running ODBC on UNIX, you must make some minor modifications.

Modifying ODBC for UNIX

To use the new 7.1 ODBC drivers, take one of the following actions:

Configure the existing odbc.ini file to point to the new drivers in <3x_SASHome>/SASFederationServer/3.x/fedserver/lib/fx*27.so. For example, change the Driver=value, to the following:
```
Driver=<3x_SASHome>/SASFederationServer/3.x/fedserver/lib/FXora27.so.
```
Use the dfdbconf tool to configure the data sources to use the new drivers. You should already have ODBCINI and ODBCINST set from a previous installation. If using dfdbconf, you must export the ODBCINI and ODBCINST environment variables again. Here are examples:
```
export ODBCINI=<3x_SASHome>/SASFederationServer/3.x/fedserver/etc/odbc.ini
```
```
export ODBCINST=<3x_SASHome>/SASFederationServer/3.x/fedserver/etc/odbcinst.ini
```
For more information, see Configuring ODBC Connections.