English
  • PowerCenter 10.2 HotFix 2
  • All Products

Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Windows
  4. Before You Upgrade the Domain on UNIX
  5. Prepare for the Upgrade
  6. Upgrade the Domain
  7. Upgrade the Domain with Changes to Node Configuration
  8. Before You Upgrade the Application Services
  9. Application Service Upgrade
  10. Informatica Client Upgrade
  11. After You Upgrade
  12. Appendix A: Updating the DynamicSections Parameter of a DB2 Database
  13. Appendix B: Upgrade Checklist

Upgrading from Version 10.0 (10.2 HotFix 2)

Upgrading from Version 10.0 (10.2 HotFix 2)

Back Next

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.