[fdo-users] FDO, Map 2007 and MySQL Server

Jack Lee jack.lee at autodesk.com
Fri Sep 28 07:38:47 EDT 2007


MySql 5.0.45 is not supported. You should do an install of 5.0.22.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Maksim Sestic
Sent: Friday, September 28, 2007 7:30 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] FDO, Map 2007 and MySQL Server

Hi all,

I'm just testing Map 2007 FDO connectivity with latest MySQL Server
Naturally, it didn't went smooth :-) Here's my list of "prerequisites":

- Latest MySQL Community Server 5.0 (5.0.45)
- Autodesk Map 3D 2007 with Service Pack 3 (acdbmgd.dll version
- OSGeo.MySQL.3.1 FDO provider that got installed along Map's SP3

First of all, there's libmySQL.dll missing in Map's ..\FDO\bin folder. I
noticed (Autodesk NGs) that people are using MySQL ODBC driver instead,
which brings in too many drawbacks. Officially, Autodesk supports MySQL
5.0.22 so I had to grab missing library from the archive (
http://downloads.mysql.com/archives.php?p=mysql-5.0 ). I just copied the
file libmySQL.dll from archive into Map's ..\FDO\bin folder and Map
started noticing present MySQL Server instance :-) Good for now...

MySQL Server has a "root" account I had to use while establishing
within Map. Service name is actually MySQL's host name (e.g. "server").
So I
went to the next step - creating named DataStore. After setting up
coordinate system parameters, along with it's extents (storage
resolution of
0.0001), I went further to see how Map creates a datastore... or
doesn't, in
my particular case :-)

Here's what happens - after the step where FDO schema and tables (f_*)
created, Map issues CreateSpatialContext which fails in a spectacular
way -
it actually kills MySQL Server instance/service! 

Do you have any suggestions or workarounds to this?

With kindest regards,
Maksim Sestic

View this message in context:
Sent from the fdo-users mailing list archive at Nabble.com.

fdo-users mailing list
fdo-users at lists.osgeo.org

More information about the fdo-users mailing list