<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>I've installed mysql 5.0 and reinstalled mapguide 2.1 and copied libmysql.dll to the fdo folder but still, the mysql user is denied access. I'm new to mysql, so perhaps I've missed something. I've set up a user with rights to a db other than the default ones and set the user's resources to values other than 0. I don't know what else to do.<BR> </DIV>
<DIV><FONT color=#0000ff>Ed Jobe</FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Jack Lee <jack.lee@sympatico.ca><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, October 21, 2009 3:49:41 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [mapguide-users] Can't connect to MySQL<BR></FONT><BR>Hi Ed,<BR><BR>depends does not necessary find the crt dlls even if it exists.<BR>I think the MySQL provider was built with 5.0.x which is not compatible with the 5.1.x client.<BR><BR><BR>Ed Jobe wrote:
<BLOCKQUOTE type="cite">
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV>Its not directly under winsxs, but in a subdir of that folder.</DIV>
<DIV>%windir%\winsxs\C:\Windows\winsxs\amd64_microsoft.vc90.crt_.....</DIV>
<DIV> </DIV>
<DIV>I'm using mysql 5.1.37</DIV>
<DIV> </DIV>
<DIV>Still though, if I run depends.exe on mysqlprovider.dll, it can't find msvcr90.dll. So I don't think its an issue with the version of mysql because the dll should have shipped with mapguide.<BR> </DIV>
<DIV><FONT color=#0000ff>Ed Jobe</FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Jack Lee <A class=moz-txt-link-rfc2396E href="mailto:jack.lee@sympatico.ca" rel=nofollow target=_blank ymailto="mailto:jack.lee@sympatico.ca"><jack.lee@sympatico.ca></A><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> MapGuide Users Mail List <A class=moz-txt-link-rfc2396E href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org"><mapguide-users@lists.osgeo.org></A><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 20, 2009 6:33:51 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [mapguide-users] Can't connect to MySQL<BR></FONT><BR>Hi Ed,<BR><BR>Did you search for msvcr90.dll under %windir%\winsxs?<BR> <BR>If the file exists, the problem might be that the MySQL provider was built with a version that is incompatible with your version of MySQL. Which version of MySQL are you
using?<BR><BR><BR>Ed Jobe wrote:
<BLOCKQUOTE type="cite">
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV>I had already tried sp1, the second link and a file search only finds msvcr80.dll. As far as the mg msi goes, I did get prompted, but I did the repair by re-running the msi, not from Control Panel. After that install, ver 9 is still not there. I may have to try again, but this time, in addition to an uninstall, make sure the install dir's are clean.<BR> </DIV>
<DIV><FONT color=#0000ff>Ed Jobe</FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Jason Birch <A class=moz-txt-link-rfc2396E href="mailto:jason@jasonbirch.com" rel=nofollow target=_blank ymailto="mailto:jason@jasonbirch.com"><jason@jasonbirch.com></A><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> MapGuide Users Mail List <A class=moz-txt-link-rfc2396E href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org"><mapguide-users@lists.osgeo.org></A><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, October 19, 2009 8:10:49 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [mapguide-users] Can't connect to MySQL<BR></FONT><BR>Try installing these; see if it makes a difference:
<DIV><BR></DIV>
<DIV>http://www.microsoft.com/downloads/details.aspx?FamilyID=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en</DIV>
<DIV><BR></DIV>
<DIV>http://www.microsoft.com/downloads/details.aspx?familyid=A5C84275-3B97-4AB7-A40D-3802B2AF5FC2&displaylang=en</DIV>
<DIV><BR></DIV>
<DIV>Only the second should be required (because that's what MG was built using) but...</DIV>
<DIV><BR></DIV>
<DIV>As an aside, MG 2.1 will not re-install the runtime in a repair install; it's done during the bootstrap phase and is not part of the MSI.</DIV>
<DIV><BR></DIV>
<DIV>Jason</DIV>
<DIV><BR>
<DIV class=gmail_quote>2009/10/19 Ed Jobe <SPAN dir=ltr><<A href="mailto:ed57gmc-bus@yahoo.com" rel=nofollow target=_blank ymailto="mailto:ed57gmc-bus@yahoo.com">ed57gmc-bus@yahoo.com</A>></SPAN><BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV>I uninstalled the runtime, rebooted, and did a repair of mapguide so it would install the redistributable from the setup package and I depends still show all the provider dll's look for version 9.<BR> </DIV>
<DIV><FONT color=#0000ff>Ed Jobe</FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV class=hm><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV class=hm><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Ed Jobe <<A href="mailto:ed57gmc-bus@yahoo.com" rel=nofollow target=_blank ymailto="mailto:ed57gmc-bus@yahoo.com">ed57gmc-bus@yahoo.com</A>><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <A href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, October 19, 2009 7:29:16 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [mapguide-users] Can't connect to MySQL<BR></FONT></DIV>
<DIV>
<DIV class=h5><BR><BR>It says that for mysqlprovider.dll, msvcr90.dll is missing. I did a windows <BR>update and the latest for the c++ runtime is msvcr80.dll.<BR>-- <BR>View this message in context: http://n2.nabble.com/Can-t-connect-to-MySQL-tp3842847p3856390.html<BR>Sent from the MapGuide Users mailing list archive at <A href="http://nabble.com/" rel=nofollow target=_blank>Nabble.com</A>.<BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR></DIV></DIV></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank
ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV><PRE><HR SIZE=4 width="90%">
_______________________________________________
mapguide-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A>
<A class=moz-txt-link-freetext href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A>
</PRE></BLOCKQUOTE></DIV></DIV></DIV><PRE><HR SIZE=4 width="90%">
_______________________________________________
mapguide-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A>
<A class=moz-txt-link-freetext href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A>
</PRE></BLOCKQUOTE></DIV></DIV></div></body></html>