Problem in Connection between MapServer and Oracle Spatial
480366Jan 11 2006 — edited Jan 11 2006Hi Everybody,
First i thanks Dan Abugov for quick reply fr my previous query.
I am working on the Oracle Spatial and MapServer
I want to clear that MapServer is not Oracle MapViewer, this is Open Source UMN MapServer.
When I pass the query(shown below), the empty image is displayed in the browser without any map
http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/sdocountry/sdocountry.map&layers=country&mode=map
I created .map file (shown below) with the Oracle Spatial Connection.
MAP
DEBUG ON
STATUS ON
SIZE 800 600
UNITS dd
IMAGECOLOR 255 255 255
PROJECTION
"proj=latlong"
"ellps=WGS84"
END
EXTENT -180 -45 180 45
LAYER
DEBUG ON
PROJECTION
"proj=latlong"
"ellps=WGS84"
END
NAME "CountryMap"
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION "world/land@orcl"
DATA "shape FROM country USING SRID 8307"
CLASS
NAME "Country_Class"
STYLE
COLOR 250 250 0
OUTLINECOLOR 32 32 32
END
END
END
END
And Set the environment variable in the apache/conf/httpd.conf file as
SetEnv ORACLE_BASE "d:/oracle/product/10.2.0"
SetEnv ORACLE_HOME "d:/oracle/product/10.2.0/db_1"
SetEnv ORACLE_SID "orcl"
SetEnv TNS_ADMIN "d:/oracle/product/10.2.0/db_1/network/admin"
This is the my whole Sample code and configuration, I dont know why the map image is not generating.
I am not receving any error message.
MapServer for windows (ms4w) binaries is downloaded from "maptools.org"
System configuration
Windows 2000 Advanced Server
Oracle 10g with Oracle Spatial
MapServer 4.6.1
Apache/2.0.55 (Win32)
I am waiting for the some solution, from you to over come this problem.
Thanks & Regards,
Prema Selvam
GISbiz.