[mapguide-users] No database connection via FDO/ODBC

[Butler, Juan P]

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.
 
- Juan 

________________________________

From: Stefan.Reuschel at dataprocess.de [mailto:Stefan.Reuschel at dataprocess.de]
Sent: Fri 6/16/2006 9:01 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] No database connection via FDO/ODBC



Hi all, 

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.

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).

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:

         "System.Net.WebException: The remote server returned an error: (559) MgFdoException. at ..." 

Only the "Refine data setup" is activated, allowing me to specify the geometry columns. 
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?

Does anyone have any suggestions? (Or do we have a "raster-provider-like" problem? ;-) 

Thanks in advance! 

Stefan Reuschel 

IT Consultant Informationssysteme
data process GmbH
Ludwig-Erhard-Straße 6
34131 Kassel
Tel: +49 (0)561 9301-1439  Fax: +49 (0)561 9301-1894
Email: stefan.reuschel at dataprocess.de
www.dataprocess.de <file://www.dataprocess.de> 
------------------------------------------------
data process GmbH
Ludwig-Erhard-Str. 6
34131 Kassel
Geschäftsführer: Dr. Ulrich Lamp
Sitz der Gesellschaft: Kassel
Handelsregister: Kassel HRB 7103 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060616/2f5dfe58/attachment.html