[mapguide-users] FDO - MySQL issues/questions

[Jason Birch]

I believe that the MySQL provider requires that a schema be defined,
though I haven't tried it myself.
 
Currently, the only way that I know of for doing this is via Autodesk's
Map 3D.  The scripts for creating the schema tables are in FDO
repository I think, so you might be able to reverse engineer the process
and create your own.
 
https://fdordbms.osgeo.org/source/browse/fdordbms/branches/3.2.x/Provide
rs/GenericRdbms/com/
 
Jason

________________________________

From: Kerndata.com [@kerndata.com] 
Sent: Tuesday, October 17, 2006 10:18
To: users at mapguide.osgeo.org
Subject: [mapguide-users] FDO - MySQL issues/questions


I'm attempting to configure a MySQL connection in MapGuide Studio 2007
using the MySQL FDO I downloaded and installed from osgeo.org.
 
It appears that the "Test Connection" functions properly (I think) but
the little box that shows whatever message it's supposed to show doesn't
show a message - just a little yield sign with no message in the box (on
user permissions errors I receive an actual message).  
 
At any rate, when I ultimately enter the correct connection information
and attempt to browse for a Data store - I receive the following
message:
 
"An exception occurred in FDO component.
RDBMS: Table 'information_schema.schemata' doesn't exist"
 
And then - 
 
"No data stores found"
 
Any insight into this error - or how to actually connect to my MySQL db
would be greatly appreciated.
 
DB = MySQL 4.1.20
 
Please advise,
 
Eric Brown
Kerndata.com
5500 Ming Avenue
Suite 160
Bakersfield, CA  93309
888.871.7205
888.603.6279 fax
support at kerndata.com
http://www.kerndata.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061017/39b169db/attachment.html