<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Database connections in MapGuide Studio</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=213481922-13032006><FONT face=Arial
color=#0000ff size=2>ODBC connections, unfortunately, not yet supported in
MapGuide Open Source. My work-around has been to create some FME scripts
that join my ODBC table fields with my Shape files before I load them through
Studio. This is obviously less than ideal.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=213481922-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=213481922-13032006><FONT face=Arial
color=#0000ff size=2>My personal opinion: while MGOS is looking good and I look
forward to the future of both MGOS and MG Enterprise, it is not feature-rich or
stable enough to replace production MapGuide 6.5 applications at this
time. The two biggest hindrances are the lack of ODBC and raster
support.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Tahoma size=1>Andy Morsell, P.E.</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Tahoma size=1>Spatial Integrators,
Inc.</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Tahoma size=1><A
href="http://www.SpatialGIS.com">http://www.SpatialGIS.com</A></FONT></SPAN>
</P>
<DIV>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Jackie Ng
[mailto:Jackie.Ng@aecsystems.com.au] <BR><B>Sent:</B> Monday, March 13, 2006
2:17 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B>
[mapguide-users] Database connections in MapGuide Studio<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Hi,<BR><BR>Is there any way to create connections to databases
in the march preview of MapGuide studio? I go to (File -> New -> Data
connection) and there is nothing listed in the "Select a feature provider"
dialog. I've asked this question before, with regards to a previous preview of
Studio, but I just want to know if it is possible to do this in this
version.<BR><BR>Just a little background...<BR><BR>We want to move our MG 6.5
maps to MapGuide Open-source. The maps are of cemeteries. Each grave/plot in a
cemetery is attributed with a unique key that we use to lookup data of the
deceased in a MS SQL server database. The actual maps converted fine without any
problems, but without a way to connect to (any) database, we can't associate
deceased data to graves/plots.<BR><BR>That's why I am so interested to know if
we can create database connections in this version of
studio.<BR><BR>Regards,<BR><BR>- Jackie Ng<BR><BR>AEC Systems</FONT>
</P></BODY></HTML>