Database clients
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 database management system client installations from the database management system vendor or download them from My Esri. The following clients can be used:
- IBM Data Server Run-time Client for DB2
- Informix Connect
- Microsoft SQL Server native client
- Netezza ODBC driver*
- Oracle Database Client*
- PostgreSQL libpq files
- Teradata ODBC driver*
*Download the Netezza driver from IBM. Download the Teradata ODBC driver and associated files (GSS client and ICU library) from Teradata. Get the Oracle Instant, Runtime, or Administrator Database Client from Oracle.
Follow the database management system client installation instructions to set up the client on your computer.
Some ArcGIS clients, such as ArcGIS for Desktop 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, Netezza, Oracle, Teradata, or 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.
If you are installing the SQL Server native client on a 64-bit operating system, use the 64-bit SQL Server native client executable. 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 are installing the IBM Data Server Run-time Client for DB2 on a 64-bit operating system, run the 64-bit executable; it installs both 32- and 64-bit files.