Re: [UMN_MAPSERVER-USERS] 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:[EMAIL PROTECTED] On Behalf Of antti siukola Sent: Friday, June 09, 2006 2:45 PM To: MAPSERVER-USERS@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?