Hi, I have never used SDE with Mapserver, but I suspect that you may be mixing Oracle spatial and ArcSDE in some way. You have Oracle database as I have understood, but are you data stored there through Oracle spatial or ArcSDE? If you are using SDE try to follow the advice from here: http://mapserver.gis.umn.edu/docs/reference/vector_data/arcsde
If your data is in native Oracle spatial format, try to follow this: http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto Perhaps you get empty map simply because your connectiontype/connection/data combination just do not find any data from the database. -Jukka Rahkonen- -----Original Message----- From: UMN MapServer Users List on behalf of José Ramón López Sent: Wed 17.10.2007 18:04 To: [email protected] Subject: [UMN_MAPSERVER-USERS] Problems with Mapserver 5 Hi list. Im trying to configure mapserver with Oracle Spatial or OCI connection This is my layer: LAYER NAME CARRETERAS TYPE LINE STATUS ON CONNECTIONTYPE OGR CONNECTION "OCI:sde/[EMAIL PROTECTED]" DATA "SDE.RED_CARRETERAS" DUMP TRUE DEBUG ON PROCESSING "CLOSE_CONNECTION=DEFER" TRANSPARENCY 0 PROJECTION "init=epsg:23030" END CLASS STYLE COLOR 0 0 0 END NAME 'Carreteras' END METADATA "wms_title" "Red Carreteras" "wms_keywordlist" "WMS Carreteras" "wms_srs" "epsg:23030" "wms_extent" "164590 4062740 579080 4266350" END END Mapserver allways send to me a blank image. I'd use shp2img , and allways send me a blank image, with this command: C:\ms4w-v5\tools\mapserv>shp2img.exe -m c:\ms4w-v5\maps\map\wms.map -i png -o C:\test.png -all_debug 9 -l CARRETERAS msDrawMap(): Layer 1 (CARRETERAS), 0.000s msDrawMap(): Drawing Label Cache, 0.000s msDrawMap() total time: 0.000s msFreeMap(): freeing map at 0144B390. and made some test for testing oracle connection with og2info, and works correctly, like: C:\ms4w-v5\tools\mapserv>ogrinfo.exe OCI:sde/[EMAIL PROTECTED]:sde.RED_CARRETERAS-SO INFO: Open of `OCI:sde/[EMAIL PROTECTED]:sde.RED_CARRETERAS' using driver `OCI' successful. 1: sde.RED_CARRETERAS if i use the command with -al option, it sends to me all information allocated in this layer. Is the problem related with system enviroment? In httd.conf: SetEnv PATH "C:/Oracle/oracle10g/BIN" SetEnv TNS_ADMIN "C:/Oracle/oracle10g/NETWORK/ADMIN" SetEnv ORACLE_SID SDE SetEnv ORACLE_BASE "C:/Oracle/oracle10g" SetEnv ORACLE_HOME "C:/Oracle/oracle10g" SetEnv LD_LIBRARY_PATH "C:\Oracle\oracle10g\LIB" and de tnsadmin.ora file SDE= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.133.19)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = sde) ) ) Windows 2003 System Enviroment: Path=\ms4w\Apache\cgi-bin;\ms4w\tools\gdal-ogr;\ms4w\tools\mapserv;\ms4w\tools\shapelib;\ms4w\proj\bin;\ms4w\tools\shp2tile;\ms4w\tools\shpdiff;\ms4w\tools\avce00;C:\oracle\Oracle10g\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem PROJ_LIB=\ms4w-v5\proj\nad ORACLE_HOME=C:\oracle\Oracle10g In ms_erro.txt file nothing is registered. Thxs
