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

[Traian Stanev]

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

  _____  

From: Stefan.Reuschel at dataprocess.de [mailto:Stefan.Reuschel at dataprocess.de] 
Sent: Friday, June 16, 2006 9:02 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/e40138b4/attachment.html