id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
2018	Entry for SDE instance not found in services file	tmelhuish@…	hobu	"{{{
I’m getting the following error when trying to connect to SDE from mapserver:

Error in msSDELayerOpen():SE_connection_create(): Entry for SDE instance not
found in services file. (-102)

I have read the documentation and search the web to try to figure out the
problem. Here is my configuration.

SDE 91 is running with Microsoft SQL on XP (IP address 10.1.3.30)
Mapserver 4.10.0 is running on Redhhat 9.0 ( I’m able to read a DB table from
Postgis and display fine)

Services file on Microsoft server under c:\windows\system32\drivers\etc\services
( last entries)
directplaysrvr  		47624/udp            #Direct Play Server
esri_sde_johnston_vector	5151/tcp		#ArcSDE for SqlServer
esri_sde_johnston_raster	5152/tcp		#ArcSDE for SqlServer
esri_sde_test_db		5153/tcp		#ArcSDE for SqlServer

The database is called “test_db” and the table is “test_db_owner.CITY_LIMITS”
that I’m trying to read

Here is the layer in the mapfile:

LAYER
    NAME         citylimits
    TYPE         POLYGON
       STATUS ON
    CONNECTION ""10.1.3.30,esri_sde_test_db,test_db,webusr,xxx""
    CONNECTIONTYPE SDE
    DATA ""test_db.test_db_owner.CITY_LIMITS,SHAPE,SDE.DEFAULT""
    TEMPLATE ""templateMS.html""
    CLASS
      NAME ""City Limits""
      STYLE
         OUTLINECOLOR 225 90 180
      END
    END
END

Please let me know if you need any further information
Thanks for your help,
Tom
}}}"	defect	closed	high		Input - Native SDE Support	4.10	normal	fixed