<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>No database connection via FDO/ODBC</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5346.5" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><FONT face=Arial
color=#0000ff size=2>What kind of ODBC data are you trying to read (does it have
geometry of its own or just attribute data for a join)? You can try to
use the OGRProvider I posted on Monday to access ODBC data sources if the ODBC
provider is not cooperating for your data. However keep in mind, that the
OGR provider currently assumes the geometry is stored in a WKT format,
unlike the ODBC provider which lets you set X and Y columns. It would be
trivial to update the OGR provider to let you set X and Y columns also, so
let me know if you decide to give it a try, I will add that
feature.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Stefan.Reuschel@dataprocess.de
[mailto:Stefan.Reuschel@dataprocess.de] <BR><B>Sent:</B> Friday, June 16, 2006
9:02 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><!-- Converted from text/rtf format -->
<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></BODY></HTML>