Le dimanche 11 mars 2012 16:41:40, gene a écrit : > Hello, may be a stupid question but I am trying to create a OGR Virtual > Format file with a SQLite database foo.db3, a table named test and columns > x, y > > > <OGRVRTDataSource> > <OGRVRTLayer name="foo"> > <SrcDataSource > relativeToVRT="1">SQLITE:database=foo.db3</SrcDataSource>
--> This is not the right syntax to open a sqlite datasource. You just have to put the filename. No need to prefix it with SQLITE:database= > <SrcSQL>select * from test </SrcSQL> > <GeometryType>wkbPoint</GeometryType> > <LayerSRS>EPSG:31370</LayerSRS> > <GeometryField encoding="PointFromColumns" x="x" y="y"/> > </OGRVRTLayer> > </OGRVRTDataSource> > > and it does not work. > > With Oracle, this works > <OGRVRTDataSource> > <OGRVRTLayer name="test"> > <SrcDataSource>OCI:user/password@server/schema</SrcDataSource> > <SrcSQL>select * from test</SrcSQL> > <GeometryType>wkbPoint</GeometryType> > <LayerSRS>EPSG:31370</LayerSRS> > <GeometryField encoding="PointFromColumns" x="x" y="y"/> > </OGRVRTLayer> > </OGRVRTDataSource>) > > What is the correct syntax for SQLite ? > > > > > -- > View this message in context: > http://osgeo-org.1560.n6.nabble.com/OGR-Virtual-Format-for-SQLite-tp456754 > 9p4567549.html Sent from the GDAL - Dev mailing list archive at Nabble.com. > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
