<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD><TITLE>Unexpected Error in contacting site URL</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 11.0in 8.5in; margin: 1.0in .8in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=blue link=blue bgColor=white>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2>I believe that the MySQL provider requires that a schema be
defined, though I haven't tried it myself.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2><A
href="https://fdordbms.osgeo.org/source/browse/fdordbms/branches/3.2.x/Providers/GenericRdbms/com/">https://fdordbms.osgeo.org/source/browse/fdordbms/branches/3.2.x/Providers/GenericRdbms/com/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=853051919-17102006><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Kerndata.com [@kerndata.com]
<BR><B>Sent:</B> Tuesday, October 17, 2006 10:18<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> [mapguide-users] FDO - MySQL
issues/questions<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT><o:p><FONT face=Arial
size=2>I'm attempting to configure a MySQL connection in MapGuide Studio 2007
using the MySQL FDO I downloaded and installed from
osgeo.org.</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>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). </FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>At any rate, when I ultimately enter the
correct connection information and attempt to browse for a Data store - I
receive the following message:</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>"An exception occurred in FDO
component.</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2>RDBMS: Table 'information_schema.schemata'
doesn't exist"</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>And then - </FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>"No data stores found"</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>Any insight into this error - or how to
actually connect to my MySQL db would be greatly appreciated.</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>DB = MySQL 4.1.20</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>Please advise,</FONT></o:p></DIV>
<DIV><o:p><FONT face=Arial size=2></FONT></o:p> </DIV>
<DIV><o:p><FONT face=Arial size=2>Eric Brown<BR>Kerndata.com<BR>5500 Ming
Avenue<BR>Suite 160<BR>Bakersfield, CA
93309<BR>888.871.7205<BR>888.603.6279 fax<BR><A
href="mailto:support@kerndata.com">support@kerndata.com</A><BR><A
href="http://www.kerndata.com">http://www.kerndata.com</A></FONT></o:p></DIV></BODY></HTML>