[mapguide-users] FDO - MySQL issues/questions

[Chris Gountanis]

I use MySQL 5.0.22 Community NT and everything works fine. I can at least
verify that. I have used Map 2007 to bulk copy SHP files to MySQL and the
only problem was authoring the layers. The preview shows nothing even with
the correct Cord Sys. Once I got to the Map Layout and manually entered the
proper X-Y everything works smooth. 


--
Chris


-----Original Message-----
From: Kerndata.com [mailto:support at kerndata.com] 
Sent: Tuesday, October 17, 2006 6:59 PM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] FDO - MySQL issues/questions

Brent,
 
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 <mailto:brent.robinson at autodesk.com>  
	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/G
enericRdbms/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