[mapguide-users] FDO - MySQL issues/questions

[Kerndata.com]

Unexpected Error in contacting site URLBrent,

I upgraded to 5.0.26-max and now I receive:

"An exception occured in FDO component.
RDBMS:"

and then:

"No data stores found."

Is there some other item I'm not understanding here?

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

  ----- Original Message ----- 
  From: Brent Robinson 
  To: users at mapguide.osgeo.org 
  Sent: Tuesday, October 17, 2006 3:01 PM
  Subject: FW: [mapguide-users] FDO - MySQL issues/questions


  MySQL 4.1.20 would be older than the minimum version supported by the MySQL provider. I'm not exactly sure what the minimum is (does anyone else know off-hand?). However, upgrading to 5.0.15 or later would get rid of the error. 



  The MySQL provider relies on some information_schema tables (which were introduced in version 5) to get information on tables, columns, etc.



  -----Original Message-----
  From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
  Sent: Tuesday, October 17, 2006 3:35 PM
  To: users at mapguide.osgeo.org
  Subject: RE: [mapguide-users] FDO - MySQL issues/questions



  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/Providers/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/d12dc8e1/attachment.html