[Mapserver-users] Virtual Spatial Data woes

[Tyler Mitchell]

Haven't use it myself, but a couple things that I heard/read about might 
be issues.
-Is Mapserver using the same ogr version you are using ogrinfo from?
-Is it set as a SYSTEM (not user) data source in ODBC?
-Jeff's page on virtual spatial data in this reference manual might help 
you:
http://omsug.ca/dl/osgis2004/MsTutorialGuide.doc

Hope that helps.

Tyler

mapserver-users-admin at lists.gis.umn.edu wrote on 07/08/2004 01:42:39 PM:

> Greetings Mapserver users,
> 
> Im having trouble getting Virtual Spatial Data to work in my
> environment:
> 
> Windows Server 2003
> SQL Server 2000 sp3
> MapServer 4.2
> 
> The problem is that I can get data out of the data base while using
> ogrinfo, but not from mapserver. 
> 
> Here is the output from a command line use of ogrinfo.
> 
> C:\Inetpub\wwwroot\VESSEL~1>ogrinfo VesselServer.ovf position
> ERROR 4: Update access not supported for VRT datasources.
> ODBC: EstablishSession(Vessels,user,password)
> OGR: OGROpen(ODBC:user/password at Vessels) succeeded (00CF3BF8).
> OGR: OGROpen(VesselServer.ovf) succeeded (00D00B88).
> Had to open data source read-only.
> INFO: Open of `VesselServer.ovf'
> using driver `VRT' successful.
> 
> Layer name: Position
> Geometry: Point
> Feature Count: 1
> ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
> ODBC: Recreating statement.
> Extent: (11.222492, 54.580212) - (11.222492, 54.580212)
> Layer SRS WKT:
> GEOGCS["WGS 84",
>     DATUM["WGS_1984",
>         SPHEROID["WGS 84",6378137,298.257223563,
>             AUTHORITY["EPSG","7030"]],
>         TOWGS84[0,0,0,0,0,0,0],
>         AUTHORITY["EPSG","6326"]],
>     PRIMEM["Greenwich",0,
>         AUTHORITY["EPSG","8901"]],
>     UNIT["degree",0.0174532925199433,
>         AUTHORITY["EPSG","9108"]],
>     AXIS["Lat",NORTH],
>     AXIS["Long",EAST],
>     AUTHORITY["EPSG","4326"]]
> id: Integer (10.0)
> longitude_dd: Real (0.0)
> latitude_dd: Real (0.0)
> ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
> ODBC: Recreating statement.
> OGRFeature(Position):0
>   id (Integer) = 10
>   longitude_dd (Real) = 11.22249187974292
>   latitude_dd (Real) = 54.58021225220185
>   POINT (11.22249188 54.58021225 0.000)
> 
> OGR: ReleaseDataSource(ODBC:user/password at Vessels/00CF3BF8) dereferenced
> and now destroying.
> 
> Here is the VesselServer.ovf file:
> 
> <OGRVRTDataSource>
>     <OGRVRTLayer name="Position">
>         <SrcDataSource>ODBC:user/password at Vessels</SrcDataSource> 
>    <SrcSQL>select * from position where id = 10</SrcSQL>
>    <GeometryType>wkbPoint</GeometryType> 
>         <LayerSRS>WGS84</LayerSRS>
>    <GeometryField encoding="PointFromColumns" x="longitude_dd"
> y="latitude_dd"/> 
>     </OGRVRTLayer>
> </OGRVRTDataSource>
> 
> Im encouraged to see that others have also had this problem. See:
> http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?OgrinfoError1
> 
> Ive also tried to re-create the database and the table (as suggested by
> some), but I still have no joy.
> 
> Can anyone offer any guidance/help. Im willing to do what I can to get
> this to go.
> 
> Thanks
> 
> Charlie Van Dusen
> IM Design
> 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users