OGR MySQL connection problem

[Volkan Ulukut]

Try this: 

 

<OGRVRTDataSource>

    <OGRVRTLayer name="layername">

<SrcDataSource>MySQL:dbname,user=user,password=password,host=localhost,port=
3306</SrcDataSource>

        <SrcSQL><SQL QUERY></SrcSQL>

 

        <GeometryField encoding="WKT" field="geom"/>

 

    </OGRVRTLayer>

 

</OGRVRTDataSource>

 

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of antti siukola
Sent: Friday, June 09, 2006 2:45 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] OGR MySQL connection problem

 

Hi!

 

I've created an ovf-file which describes a layer like this

********************************************************

<OGRVRTDataSource>

 

    <OGRVRTLayer name="layername">

<SrcDataSource>MYSQL:layername,user=user,password=password,host=localhost,po
rt=3306</SrcDataSource>

        <SrcSQL><SQL QUERY></SrcSQL>

 

        <GeometryField encoding="WKT" field="geom"/>

 

    </OGRVRTLayer>

 

</OGRVRTDataSource>

********************************************************

and ogrinfo gives me this

********************************************************

ogrinfo kaavahanke.ovf

ERROR 4: Update access not supported for VRT datasources.

ERROR 1: Failed to open datasource

 
`MYSQL:layername,user=user,password=password,host=localhost,port=3306'.

FAILURE: Unable to open datasource `filename.ovf' with the following
drivers.

 

<list of drivers including VRT>

********************************************************

I'm using GDAL 1.3.2. and MapServer 4.8.3.

 

What have I configured incorrectly?

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060609/bd7862b9/attachment.html