Dear Richard,
You can use it in your map file as the following
LAYER
NAME "basemap"
STATUS on
TYPE polygon
CONNECTIONTYPE OGR
CONNECTION "<OGRVRTDataSource>
<OGRVRTLayer name=basemap>
<SrcDataSource>OCI:usename/password</SrcDataSource>
<SrcLayer>BASEMAP</SrcLayer>
<SrcSQL>select * from basemap</SrcSQL>
<GeometryType>wkbPolygon</GeometryType>
</OGRVRTLayer>
</OGRVRTDataSource>"
data "basemap"
TEMPLATE "ttt"
TOLERANCE 4
CLASS
NAME "Basemap"
OUTLINECOLOR 80 80 80
COLOR 219 0 0
SIZE 12
END
END
Regards
Maher Abdel Karim
GIS system analyst/developer
DC Water and Environment
|---------+------------------------------->
| | richard orama |
| | <[EMAIL PROTECTED]|
| | COM> |
| | Sent by: UMN |
| | MapServer Users List|
| | <[EMAIL PROTECTED]|
| | TS.UMN.EDU> |
| | |
| | |
| | 09/02/2007 08:33 AM |
| | Please respond to |
| | richard orama |
|---------+------------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [email protected]
|
| cc:
|
| Subject: [UMN_MAPSERVER-USERS] Mapserver-to-Oracle Connection
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
First, I appreciate all your help for the last about 1 week when I started
venturing into Mapserver. I have made a real big headway into this thing.
Now, I need to have Mapserver connect to an ordinary non-spatial Oracle
database (no x,y columns) so that the data retreived from Oracle are used
in my maps. I have tried ODBC but it only works where the Oracle table has
x,y columns.
Any help?
Richard Orama.
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
