HOW TO
RDBMS tables can be loaded into ArcMap via OLE DB connections. In some situations, it may be necessary to redirect ArcMap to connect to a different database using the same OLE DB connection. ArcMap stores OLE DB connection information in the Map project file. For this reason, even if it is reconfigured to connect to a different server, ArcMap will still attempt to connect to the original server when reopening the map project.
Note:
The steps for creating a DSN vary depending upon the database type and version of the ODBC driver. For some databases, such as Oracle, it is also necessary to install the DBMS client software before it is possible to configure the DSN.
Article ID:000005920
Get help from ArcGIS experts
Download the Esri Support App