How To: Cannot connect to ArcSDE via ArcIMS Author
ArcSDE may not be accessible for connection using ArcIMS Author. There may be several different reasons for this.
To troubleshoot this issue verify the following:
ArcSDE works with most codepages, but it is not presently supported running in a mixed code page environment. All of the spatial databases should have the same collation as the 'sde' database.
Verify that the JAVA_HOME environment variable is set to the JDK installation directory. Verify this is referenced in the PATH variable as %JAVA_HOME%\bin.
When using Oracle Spatial Data, check the values of SRID. Author is sensitive to certain values for SRID. For example: 90112.
When the database has a layer with a projection description containing spaces in it, Author connects but fails to list layers. All of the data layers are viewable in ArcGIS.
For example, the following projection description has a spheroid containing spaces:
Code: PROJCS["WGS 1984 UTM",GEOGCS["unnamed",DATUM["D_WGS_1984",SPHEROID["World Geodetic System of 1984", 6378137.0,298.257222932867]],PRIMEM["Greenwich",0.0],UNIT["degree",0.0174532925199433]],PROJECTION ["Transverse_Mercator"],PARAMETER["false_easting",500000.0],PARAMETER["false_northing",0.0],PARAMETER ["central_meridian",-75.0],PARAMETER["scale_factor",0.9996],PARAMETER["latitude_of_origin",0.0], UNIT["METER",1.0]]
To find this information, execute the "sdelayer -o describe_long" command with appropriate parameters for each layer in the ArcSDE database on the ArcSDE Server.
To resolve this problem in ArcIMS, remove the layer and reload with a new projection containing no spaces.
Check the parameters in the add ArcSDE Connection dialogue box.
If experiencing problems with connecting, change the Server from hostname to the IP address of ArcSDE computer.
Verify the correct instance information is supplied; for example, port:5151. Where 5151 is the default port on which ArcSDE is listening.
Verify that the IP address/hostname of the ArcSDE machine is listed in the HOSTS file for the ArcIMS machine. The HOSTS file can be found in C:\WINNT\system32\drivers\etc.
The contents of the file, should appear as follows:
Code: # Copyright (c) 1993-1999 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 22.214.171.124 rhino.acme.com # source server # 126.96.36.199 x.acme.com # x client host
127.0.0.1 localhost 188.8.131.52 esri.com #ArcIMS Server 184.108.40.206 sde.com #ArcSDE Server
For hanging connections between ArcIMS Author and ArcSDE on UNIX platforms, refer to the article in the Related Information section below.