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 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.
