OGR MySQL connection problem

antti siukola siukola.antti at GMAIL.COM
Fri Jun 9 08:21:08 EDT 2006


I still get "Unable to open datasource `kaavahanke.ovf' with the
following drivers."
and the driver list belox it.

AnttiS

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



More information about the mapserver-users mailing list