It is recommended that you upgrade all your Microsoft SQL Server connections to use the ODBC provider type. You can upgrade all your Microsoft SQL Server connections to the ODBC provider type by using the following commands:

If you are using PowerCenter, run the following command:
pmrep upgradeSqlServerConnection
If you are using the Informatica platform, run the following command:
infacmd.sh isp upgradeSQLSConnection

After you run the upgrade command, you must set the environment variable on each machine that hosts the Developer tool and on the machine that hosts Informatica services in the following format:

ODBCINST=<INFA_HOME>/ODBC7.1/odbcinst.ini 

After you set the environment variable, you must restart the node that hosts the Informatica services.