Virtual Spatial Data and MySQL client

[Piero Cavalieri]

Bart van den Eijnden wrote:

>Hi list,
>
>I can't connect to a MySQL database using the MySQL client in OGR. I am
using MySQL client 4.1 on a 4.1 localhost database. It works fine through
ODBC.
>
>With the following ovf file:
>
><OGRVRTDataSource>
>    <OGRVRTLayer name="bedrijven">
>
<SrcDataSource>MYSQL:user=root,password=psv9570,port=3306,database=westholla
nd</SrcDataSource>
>  <SrcLayer>bedrijven</SrcLayer>
> <GeometryType>wkbPoint</GeometryType>
>        <LayerSRS>epsg:28992</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="LCO_XCOORDINAAT"
y="LCO_YCOORDINAAT"/>
>    </OGRVRTLayer>
></OGRVRTDataSource>
>
>Thanks in advance (again :-) ).

Never used MySQL, however: where is the HOST name i SrcDataSource ?


>Best regards,
>Bart
>
>Bart van den Eijnden
>Syncera IT Solutions
>Postbus 270
>2600 AG  DELFT
>
>tel.nr.: 015-7512436
>email: BEN at Syncera-ITSolutions.nl
>