[mapserver-users] Log instance of ArcSDE 9.2 from mapserver.Multiple geodatabases in one Oracle database

[richard sivila rios]

Please help me I have the following problem:


I am currently using this software (all this running on linux): 

For Linux:
centos 5.2
oracle 10.2.0.1.0
arcsde version 9.2 para linux
mapserver 5.2.0
ArcGis Desktop 9.2 

Create an instance in my database server with ArcSDE

./sdesetup -o install -d ORACLE10G -i 5151:ucatastro -u ucatastro -p ucatastro

and were as follows:


ArcSDE Instance esri_sde's instances on richard at Sun Aug 23 12:45:16 2009
-------------------------------------------------------------------------
Instance Created Id
-------------------- -------------------------------- ------------------------
SDE Fri Feb 6 20:18:33 2009 0
UCATASTRO Sat Aug 22 23:48:23 2009 1 

* And create versions for my database:


2 versions found:

Instance default version.
------------------------------------------------------------
Version Name: SDE.DEFAULT
Version ID: 1
Parent Version Name:
Parent Version ID: 0
State ID: 0
Access: Public
Creation Time: Fri Feb 6 20:18:05 2009


------------------------------------------------------------
Version Name: SDE.PRUEBA
Version ID: 2
Parent Version Name: SDE.DEFAULT
Parent Version ID: 1
State ID: 0
Access: Public
Creation Time: Tue Apr 28 18:11:47 2009

    

? My question is how do I connect to the instance UCATASTRO from mapserver. Since this achievement to do it without problems from ArcGIS Desktop 9.2. ?

A below specifies the parameters of how I connect from ArcGIS 9.2 DESKTOP:

Server: 10.0.0.100
Service: 5151:catastro
username: ucatastro
password: ucatastro
The following transactional version will be used
UCATASTRO.DEFAULT


Note: At the request sde.DEFAULT successfully made it without problems.

Here are my file let mapserver 

MAP
IMAGETYPE PNG24
# lef bottom right top
EXTENT 315769.467192 7611318.459955 327688.472240 7624271.824586
SIZE 800 600
IMAGECOLOR 255 255 255
#WEB
# TEMPLATE 'index.html'
# IMAGEPATH '/ms4w/Apache/htdocs/raster/tmp/'
# IMAGEURL 'tmp'
#END

LAYER
NAME states
TYPE POLYGON
CONNECTION "127.0.0.1,port:5151,noimporta,ucatastro,ucatastro"
CONNECTIONTYPE SDE
DATA "pprueba,SHAPE,SDE.PRUEBA"
PROCESSING "QUERYORDER=ATTRIBUTE" # <-- MapServer 4.10 and above
# PROCESSING "JOINTABLE=SDE_MASTER.GEOSERVWRITE.JOINTABLE"
# CLASSITEM "SDE_MASTER.GEOSERVWRITE.JOINTABLE.VAL"
# FILTER "SDE_MASTER.GEOSERVWRITE.JOINTABLE.AQ_TAG=SDE_MASTER.GEOSERVWRITE.JOINTESTLAYER.AQ_TAG"
PROCESSING "OBJECTID=OBJECTID"
TEMPLATE '/where/the/template/file/is/located'
CLASS
STYLE
# SYMBOL 'circle'
SIZE 3
COLOR -1 -1 -1
OUTLINECOLOR 0 0 0
END
END
END


_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090824/0b3a8cc8/attachment.html