<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>No database connection via FDO/ODBC</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText24024 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I've noticed that the
procedure to add an ODBC connection and then adding a subsequent data extension
can be quite troublesome. When I add and ODBC connection it's fine.
It's when I go to add a primary key or if the table has coordinate values,
trying to select the x, y fields. It constantly errors out and it's
a series of saves and shutting down of Studio that it finally allows me to
select the fields. Not sure why this is so difficult, but it has cost
me some time in getting setup.</FONT></DIV><FONT face=Arial size=2></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>- Juan</FONT>
<DIV dir=ltr><BR></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B>
Stefan.Reuschel@dataprocess.de
[mailto:Stefan.Reuschel@dataprocess.de]<BR><B>Sent:</B> Fri 6/16/2006 9:01
AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> [mapguide-users] No
database connection via FDO/ODBC<BR></FONT><BR></DIV></DIV>
<DIV>
<P><FONT face=Arial size=2>Hi all,</FONT> </P>
<P><FONT face=Arial size=2>until now I was not successful in connecting to a
simple local Access database via the most recent downloadable FDO provider for
ODBC connections. Generally it shouldn't be impossible, since once or twice I
got a successfully established connection.</FONT></P>
<P><FONT face=Arial size=2>I'm successfully testing an "out of the box" MapGuide
OS 1.0.0 (bundled, with Apache/PHP/Tomcat) and MapGuide Studio preview 2007,
both together installed on 1. w2k Server (SP4) or 2. XP (SP1).</FONT></P>
<P><FONT face=Arial size=2>Previews, Layout management etc. work (mostly) fine
so far, but as soon as I try to test the connection (either connection string or
data source name), I permanently receive the previously mentioned
error:</FONT></P>
<P><FONT face=Arial size=2>
"System.Net.WebException: The remote server returned an error: (559)
MgFdoException. at ..."</FONT> </P>
<P><FONT face=Arial size=2>Only the "Refine data setup" is activated, allowing
me to specify the geometry columns.</FONT> <BR><FONT face=Arial size=2>The
mgserver.exe process keeps the database locked, even if MapGuide Studio is shut
down. The process has to be killed first, and then the lockfile *.mdl has to be
deleted manually before any further access to the db is possible. Restarting or
introducing "new" system databases did not help. What else?</FONT></P>
<P><FONT face=Arial size=2>Does anyone have any suggestions? (Or do we have a
"raster-provider-like" problem? ;-)</FONT> </P>
<P><FONT face=Arial size=2>Thanks in advance!</FONT> </P>
<P><FONT face=Arial size=2>Stefan Reuschel </FONT></P>
<P><FONT face=Arial size=2>IT Consultant Informationssysteme<BR>data process
GmbH<BR></FONT><FONT face=Arial size=2>Ludwig-Erhard-Straße 6<BR>34131
Kassel</FONT><BR><FONT face=Arial size=1>Tel: +49 (0)561 9301-1439 Fax:
+49 (0)561 9301-1894</FONT><BR><FONT face=Arial size=1>Email:
stefan.reuschel@dataprocess.de</FONT><BR><A
href="file://www.dataprocess.de"><U></U><U><FONT face=Arial color=#0000ff
size=1>www.dataprocess.de</FONT></U></A><BR><FONT face=Arial
size=2>------------------------------------------------<BR></FONT><FONT
face=Arial size=1>data process GmbH<BR>Ludwig-Erhard-Str. 6<BR>34131
Kassel</FONT><BR><FONT face=Arial size=1>Geschäftsführer: Dr. Ulrich
Lamp<BR>Sitz der Gesellschaft: Kassel<BR>Handelsregister: Kassel HRB 7103</FONT>
</P></DIV>
</BODY>
</HTML>