OGR MySQL connection problem

[Volkan Ulukut]

Try while having only the <SrcDataSource> option. I guess your problem is in
the connection string. You have to give the database name not the
table(layer)name after "MySQL:" expression and try ogrinfo again

-----Original Message-----
From: antti siukola [mailto:siukola.antti at gmail.com] 
Sent: Friday, June 09, 2006 3:07 PM
To: Volkan Ulukut; MAPSERVER-USERS at lists.umn.edu
Subject: Re: [UMN_MAPSERVER-USERS] OGR MySQL connection problem

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