Bug: 3-tier connection fails or hangs when ArcGIS Desktop, ArcSDE (64-bit), and Database (64-bit) are all on same 64-bit machine


Instructions provided describe how to connect using a 3-tier connection when ArcGIS Desktop, ArcSDE, and a database are on the same machine. This is a workaround for occurances of a 3-tier connection failure when ArcGIS Desktop, ArcSDE (64-bit), and Database (64-bit) are all on same 64-bit machine.


This is a known issue.


If ArcSDE 64-bit is installed on the same server as a 32-bit client (for example, ArcGIS Desktop, ArcGIS Server, or ArcIMS), one of the following must be done:

  • Create a new System variable in Windows, where SDEFORCEXDR has the value of 1 (true) by following these steps:

    1. In Windows, click Start. Right-click My Computer and select Properties.
    2. In the System Properties window, click the Advanced tab.
    3. Click the Environment Variables button.
    4. In the Environment Variables window, in the System variables group, click New.
    5. In the New System Variable window, in the variable name field, type 'SDEFORCEXDR'.
    6. In the Variable value field, type '1'. Click OK.

    If the client system variable is not set, the client and ArcSDE attempts to use the same shared memory, and the client connection to the geodatabase fails.

  • Use a fully qualified domain name (e.g., sslghost6.esri.com) or the IP address in the 'Server' column in the Connection Properties window.
  • Use Direct Connection with Oracle Client (32-bit) installed on the same 64-bit machine.
  • Connect from a remote machine (32-bit or 64-bit).