When you load a Microsoft SQL Server resource, the PowerCenter Integration Service uses ODBC to connect to the Microsoft SQL Server database. You must set the ODBCINST environment variable to enable the PowerCenter Integration Service to access the ODBC driver.
On the machine that runs the PowerCenter Integration Service, set the ODBCINST environment variable to the location of the odbcinst.ini file. For example:
ODBCINST=<INFA_HOME>/ODBC7.1/odbcinst.ini
Restart the domain after you set the environment variable.