Upgrade the Connection Provider Type for Microsoft SQL Server
Upgrade the Connection Provider Type for Microsoft SQL Server
After you upgrade, the Microsoft SQL Server connection is set to the OLEDB provider type by default.
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.