Yeap,
<OGRVRTDataSource>
<OGRVRTLayer name="data">
<SrcDataSource>MYSQL:data,user=root,password=*****,host=localhost,port=3306,tables=data</SrcDataSource>
<SrcSQL>SELECT ....</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
Any other idea?
Attila
Anakreon Mentis írta:
Does the url contains the usr and pswd?
For me it works and the ovf file is:
<OGRVRTDataSource>
<OGRVRTLayer name="sites">
<SrcDataSource>MYSQL:db_test,user=root,password=,host=localhost,port=3306,tables=site</SrcDataSource>
<SrcSQL>
query
</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
--
Berényi Attila Attila Berényi
térinformatikus GIS engineer
Burken Kft. Burken Ltd.
--------------------------------------
H-1155 Budapest, Obsitos tér 2.
Tel.: +36-1-415-0219
+36-1-415-0220
Fax: +36-1-410-1314
E-mail: [EMAIL PROTECTED]
