[Mapserver-users] Virtual Spatial Data woes

[IMD Listuser]

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