Chris,
try this, if you have not done it, in the geometry field of your .ovf file,
replace "x" and "y" with the name of the columns of the waarnemingen table
that represents the xcoord and ycoord respectively, e.g.:
<GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
Regards,
Gaston.
----- Original Message -----
From: "Chris Beaart" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, February 07, 2007 4:12 PM
Subject: [UMN_MAPSERVER-USERS] Problem with connecting to MySQL with
OVF-file
Hello,
I'm running Mapserver and pMapper on a Linux-Debian system and I have
installed MySQL, added a database called dop and a table called
waarnemingen.
I created a waarnemingen.ovf which looks like this:
<OGRVRTDataSource>
<OGRVRTLayer name="Waarnemingen">
<SrcDataSource>MYSQL:dop,user=root,password=testje,host=84.244.182.83,port=3
306,tables=waarnemingen</SrcDataSource>
<SrcSQL>SELECT * FROM waarnemingen</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
When I run ogrinfo /var/www/data/maps/waarnemingen.ovf I get the following
message:
ERROR 4: Update access not supported for VRT datasources.
ERROR 1: Failed to open datasource
`MYSQL:dop,user=root,password=trashcan,host=84.244.182.83,port=3306,tables=w
aarnemingen'.
FAILURE:
Unable to open datasource `/var/www/data/maps/waarnemingen.ovf' with the
following drivers.
-> ESRI Shapefile
-> UK .NTF
-> SDTS
-> TIGER
-> S57
-> MapInfo File
-> DGN
-> VRT
-> AVCBin
-> REC
-> Memory
-> CSV
-> GML
-> ODBC
-> PostgreSQL
The host is the IP-number of the server where MySQL is running. Using
localhost or 127.0.0.1 results in the same errors.
Can somebody please help to connect to MySQL database. What could be
wrong?
Thanks.
Chris Beaart
