mysql ogr connection

[Berényi Attila]

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:	aberenyi at burken.hu