Mapserver-to-Oracle Connection

[Maher Karim]

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       |
|         |           <richardorama at YAHOO.|
|         |           COM>                |
|         |           Sent by: UMN        |
|         |           MapServer Users List|
|         |           <MAPSERVER-USERS at LIS|
|         |           TS.UMN.EDU>         |
|         |                               |
|         |                               |
|         |           09/02/2007 08:33 AM |
|         |           Please respond to   |
|         |           richard orama       |
|---------+------------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |        To:      MAPSERVER-USERS at LISTS.UMN.EDU                                                                                                    |
  |        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.