Strange OGR VRT Issue

[Murat BEYHAN]

Tom

sorry for the previous e mail, I was made a mistake,

Please change the line in your new ovf file with the following line

<SrcDataSource>ODBC:****/****@CABIN,OGRPoints</SrcDataSource>

regards...

Murat

On Thu, 12 Oct 2006 22:57:30 +0300, Murat BEYHAN wrote
> Tom, 
> At the following line I think, but I'm not sure, You should write the name of table as your old ovf file. 
> 
> >         <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource> 
> 
> Please try to change the line as follows, 
> <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource,OGRPoints> 
> Good luck... 
> Murat 
> On Thu, 12 Oct 2006 13:10:33 -0400, Pascoe,Tim [Burlington] wrote 
> > I'm experimenting with placing my OVF file in line, in order to pass in some variables for a custom WHERE Statement. The first step I took was changing my OVF file to use the scrSQL tag with a very simple SQL statement, instead of the srcLayer tag. Both OVF files point to the same view, in the same database. 
> > New File: 
> > <OGRVRTDataSource> 
> >     <OGRVRTLayer name="CABINPoints"> 
> >         <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource> 
> >         <SrcSQL>SELECT * FROM OGRPoints</SrcSQL> 
> >           <FID>sitedetailsid</FID> 
> >         <GeometryType>wkbPoint</GeometryType> 
> >         <LayerSRS>WGS84</LayerSRS> 
> >     <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/> 
> >     </OGRVRTLayer> 
> > </OGRVRTDataSource> 
> > Old FIle: 
> > <OGRVRTDataSource> 
> >     <OGRVRTLayer name="CABINPoints"> 
> >         <SrcDataSource>ODBC:****/****@CABIN,OGRPoints</SrcDataSource> 
> >         <SrcLayer>OGRPoints</SrcLayer> 
> >           <FID>sitedetailsid</FID> 
> >         <GeometryType>wkbPoint</GeometryType> 
> >         <LayerSRS>WGS84</LayerSRS> 
> >     <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/> 
> >     </OGRVRTLayer> 
> > </OGRVRTDataSource> 
> > The problem is, the old OVF returns a proper image, while the new one returns a blank image. I ran the new file through OGRInfo and shp2ogr, and both behave properly. 
> > So……..why am I getting a blank image with the scrSQL tag? I'm using the latest version of the MS4W file set, but running on IIS on Windows 2000. Any suggestions would be great - it's probably somthing very simple I'm missing :) 
> > Tim Pascoe 
> > -- 
> > This message has been scanned for viruses and 
> > dangerous content by MailScanner, and is 
> > believed to be clean. 
> 
> -- 
> Open WebMail Project (http://openwebmail.org) 
> 
> 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner, and is 
> believed to be clean.

-- 
Open WebMail Project (http://openwebmail.org)

 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061012/e5aeb1d7/attachment.htm>