<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>No database connection via FDO/ODBC</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial"> "System.Net.WebException: The remote server returned an error: (559) MgFdoException. at ..."</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Only the "Refine data setup" is activated, allowing me to specify the geometry columns.</FONT>
<BR><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">Does anyone have any suggestions? (Or do we have a "raster-provider-like" problem? ;-)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks in advance!</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Stefan Reuschel </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">IT Consultant Informationssysteme<BR>
data process GmbH<BR>
</FONT><FONT SIZE=2 FACE="Arial">Ludwig-Erhard-Straße 6<BR>
34131 Kassel</FONT><BR>
<FONT SIZE=1 FACE="Arial">Tel: +49 (0)561 9301-1439 Fax: +49 (0)561 9301-1894</FONT><BR>
<FONT SIZE=1 FACE="Arial">Email: stefan.reuschel@dataprocess.de</FONT><BR>
<A HREF="file://www.dataprocess.de"><U></U><U><FONT COLOR="#0000FF" SIZE=1 FACE="Arial">www.dataprocess.de</FONT></U></A><BR>
<FONT SIZE=2 FACE="Arial">------------------------------------------------<BR>
</FONT><FONT SIZE=1 FACE="Arial">data process GmbH<BR>
Ludwig-Erhard-Str. 6<BR>
34131 Kassel</FONT><BR>
<FONT SIZE=1 FACE="Arial">Geschäftsführer: Dr. Ulrich Lamp<BR>
Sitz der Gesellschaft: Kassel<BR>
Handelsregister: Kassel HRB 7103</FONT>
</P>
</BODY>
</HTML>