Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain
  4. Prepare for the Upgrade
  5. Upgrade the Domain
  6. Upgrade the Domain with Changes to Node Configuration
  7. Before You Upgrade the Application Services
  8. Application Service Upgrade
  9. Informatica Client Upgrade
  10. After You Upgrade
  11. Upgrade Checklist

Upgrading from Version 10.1

Upgrading from Version 10.1

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.