Is This Content Helpful?
We're glad to know this article was helpful.
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.
Instructions provided describe how to set up OLE DB connections so ArcMap will automatically recognize when they have been reconfigured to connect to different servers.
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.