[ms4w-users] stored-procedure with SQLServer into file.map

[Victor Herrero Cazurro]

I have a configuration file.map with this parameters:

"<OGRVRTDataSource>
    <OGRVRTLayer name='layer1'>
	<SrcDataSource>ODBC:user/pass at SQLServer</SrcDataSource>
	<SrcSQL>EXEC storeProcedure1</SrcSQL>
	<FID>id</FID>
	<GeometryType>wkbPoint</GeometryType>
	<LayerSRS>WGS84</LayerSRS>
	<GeometryField encoding='PointFromColumns' x='x' y='y'/>
        </OGRVRTLayer>
</OGRVRTDataSource>"

The "storeProcedure1" is a stored-procedure which executed in SQLServer, 
obtain multiple point to table. But this configuration in file.map not 
obtain nothing.

I have proven with the command:

c:\ogrinfo virtual.ovf

where virtual.ovf is this

<OGRVRTDataSource>
    <OGRVRTLayer name="layer1">
      <SrcDataSource>ODBC:user/pass at SQLServer</SrcDataSource>
	<SrcSQL>EXEC storeProcedure1</SrcSQL>
	<FID>id</FID>
	<GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
	<GeometryField encoding="PointFromColumns" x="x" y="y"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

And the result

ERROR 4: Update access not supported for VRT datasources.
Had to open data source read-only.
INFO: Open of `virtual.ovf'
      using driver `VRT' successful.
1: layer1 (Point)


Somebody can help me?

thanks

_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de un millón de canciones. 
http://music.msn.es/