A database client is required on all machines that connect to a database management system. The database client release must be compatible with the release of the database management system to which you are connecting.
You can obtain the following database management system client installations from the database management system vendor or download them from My Esri:
- IBM Data Server Run-time Client for DB2
- Informix Connect
- Microsoft SQL Server native client
- Microsoft ODBC driver 11 for SQL Server
- PostgreSQL libpq files*
*ArcGIS 10.3 for Desktop, Server, and Engine include the required PostgreSQL files; therefore, you only need to obtain PostgreSQL client files if you need to connect from other clients.
The following clients must be obtained from the database management system vendor:
- ALTIBASE HDB Client
- Netezza ODBC driver
- Oracle Database Client*
- SAP HANA ODBC driver
- Teradata ODBC driver and associated files (GSS client and ICU library)
*ArcGIS does not support using Oracle 10g database clients.
Follow the database management system client installation instructions to set up the client on your computer.
Some ArcGIS clients, such as ArcMap and ArcGIS Engine, are 32-bit applications. If you are making a database connection from one of these clients, you must use a 32-bit Informix, ALTIBASE, SAP HANA, Netezza, Oracle, Teradata 14.x, PostgreSQL database management system client to connect to the database. This is true even if you install the ArcGIS client application on a computer with a 64-bit operating system and the database and server operating system are 64 bit. To connect from 64-bit ArcGIS clients, you must install 64-bit database management system clients.
Use the 64-bit SQL Server native client executable to install on a 64-bit operating system. The executable detects the type of operating system and installs the correct database management system client. If you run the 32-bit SQL Server native client on a 64-bit operating system, it will fail.
If you install the IBM Data Server Run-time Client for DB2 or Teradata 15 client on a 64-bit operating system, run the 64-bit executable; these clients install both 32- and 64-bit files.Feedback on this topic?