ODBC Drivers

Overview

SAS Federation Server 4.1 is installed with release 7.10 of the Wire Protocol ODBC drivers. The installation directory for Windows has changed to

C:\Program
                     Files\DataFlux\ODBC\7.1

. All of the existing ODBC DSNs should use the new 7.10 Wire Protocol ODBC drivers, and modifications are not necessary. If you are running ODBC on UNIX, you must make some minor modifications as presented in the next topic.

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 <4.1_SASHome>/SASFederationServer/4.1/fedserver/lib/fx*27.so. For example, change the Driver=value to:
```
Driver=<4.1_SASHome>/SASFederationServer/4.1/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 environment variable. The environment variable for ODBCINST is set when you execute dfsadmin for SAS Federation Server 4.1. Here are export examples:
```
export ODBCINI=<4.1_SASHome>/SASFederationServer/3.x/fedserver/etc/odbc.ini
```
```
export ODBCINST=<4.1_SASHome>/SASFederationServer/3.x/fedserver/etc/odbcinst.ini
```
For more information, see “Configuring ODBC Connections”.