[Mapserver-users] virtual spatial data

[Paul Spencer]

nothing seems obviously wrong.  A couple of things to try:

* SrcLAYER -> SrcLayer ... I'd be suprised it if was case-sensitive, but 
you never know ;)

* <SrcDataSource>ODBC:sa at localserver</SrcDataSource> or
   <SrcDataSource>ODBC:localserver</SrcDataSource> - my idea here is 
that the / is possibly an invalid character inside an XML element?  And 
the parsing may not be handled the same way between ogrinfo and 
mapserver because of the inclusion of xerces in mapserver?  Just a wild 
guess on this one ..

Cheers,

Paul

Jenu Abraham wrote:
> hi,
> I'm using windows 2003 server with mapserver-4.1-dev-win32-php4.3.4 
> binaries (This is precompiled with GDAL)
> i have loaded the gdal12.dll in the winnt/system folder
> 
> and the testing2.ovf file works perfect with ogrinfo
> 
> I have tried to run it in the inline connection mode and the file 
> connection mode...
> when i run mapserver i get this error listed below- I cant figure out 
> whats wrong-
> 
> the error with the inline connection string- (inside mapfile- commented 
> out in the source below)
> --------------------------------------
> msDrawMap(): Image handling error. Failed to draw layer named 'trucks'.
> msOGRFileOpen(): OGR error. Open failed for OGR connection ` 
> ODBC:sa/@localserver latlong wkbPoint WGS84 '. File not found or 
> unsupported format.
> ---------------------------------------
> 
> ------------------------------------------
> 
> The error with the connection in the testing.ovf file
> --------------------------------------
> msDrawMap(): Image handling error. Failed to draw layer named 'trucks'.
> msOGRFileOpen(): OGR error. Open failed for OGR connection 
> `C:\cgi-bin\testing2.ovf'. File not found or unsupported format.
> 
> $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
> testing2.ovf
> $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
> <OGRVRTDataSource>
> <OGRVRTLayer name="mylayer">
> <SrcDataSource>ODBC:sa/@localserver</SrcDataSource>
> <SrcLAYER>latlong</SrcLAYER>
> <GeometryType>wkbPoint</GeometryType>
> <LayerSRS>WGS84</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="x" y="y"/>
> </OGRVRTLayer>
> </OGRVRTDataSource>
> $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
> 
> @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
> mapfile
> @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
> MAP
>  NAME           e-test-rd-jbox_
>  IMAGETYPE      GIF
>  EXTENT          -2236857.50 -1744057.00  2786329.50 29069.36
> 
>  SIZE           800 600
>  SHAPEPATH      "C:\cgi-bin\data\"
> 
>  FONTSET        "C:\cgi-bin\fonts\fonts.list"
> 
>  WEB
>    TEMPLATE 'e-test-rd-jbox.html'
>    IMAGEPATH 'C:\cgi-bin\tmp\'
>    IMAGEURL  '/tmp/'
>  END
> 
>  PROJECTION
>   "init=epsg:2163"
>  END
> 
> 
>  LAYER # States polygon layer begins here
>    NAME         states
>    DATA         statesp020
>    STATUS       DEFAULT
>    TYPE         POLYGON
> 
>    PROJECTION
>      "init=epsg:4326"
>    END
>     CLASS
>        COLOR      240 240 100
>    END
>  END # States polygon layer ends here
> 
> LAYER # start of truck position from database
>     NAME trucks
>     TYPE POINT
>     CONNECTIONTYPE OGR
>      CONNECTION "C:\cgi-bin\testing2.ovf" # file connection
>     #CONNECTION '<OGRVRTDataSource> # inline connection
>     #        <OGRVRTLayer name="mylayer">
>     #        <SrcDataSource>ODBC:sa/@localserver</SrcDataSource>
>     #        <SrcLAYER>latlong</SrcLAYER>
>     #        <GeometryType>wkbPoint</GeometryType>
>     #        <LayerSRS>WGS84</LayerSRS>
>     #        <GeometryField encoding="PointFromColumns" x="x" y="y"/>
>     #        </OGRVRTLayer>
>     #        </OGRVRTDataSource>'
>     DATA "mylayer"
>     STATUS DEFAULT
>     #LABELITEM latlong.name
>     PROJECTION
>              "init=epsg:4326"
>     END
>     CLASS
>         SYMBOL 1
>         SIZE 6
>              COLOR      255 0 0
>         #LABEL
>         #    SIZE MEDIUM
>         #    TYPE BITMAP
>         #    COLOR 0 0 0
>         #END
>      END
> 
> END # end of connection layer
> 
>  # End of LAYER DEFINITIONS
> END # end of map file
> 
> @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
> 
> 
> Jenu
> 
> _________________________________________________________________
> Watch LIVE baseball games on your computer with MLB.TV, included with 
> MSN Premium! http://join.msn.click-url.com/go/onm00200439ave/direct/01/
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 

-- 
  -----------------------------------------------------------------
|Paul Spencer                           pspencer at dmsolutions.ca   |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------