OGR MySQL connection problem

[antti siukola]

Thanks for a quick reply!

That didn't do it... D*mn

On 6/9/06, Volkan Ulukut <vulukut at tescilturk.com> wrote:
>
>
>
>
> 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,port=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?
>
>
>