Virtual Spatial Data and MySQL client

[Bart van den Eijnden]

Hi Piero,

the host parameter defaults to localhost and that's where my database is  
situated.

Best regards,
Bart

On Thu, 21 Jul 2005 17:34:59 +0200, Piero Cavalieri  
<piero.cavalieri at HEIDI.IT> wrote:

> 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
>>
>



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/