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

[Andrew DeMerchant]

Same problem here.....anyone have a solution to this?

Butler, Juan P wrote:

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

-- 
	*Andrew DeMerchant*
*Computer Technologist*
ph.1-877-4GEMTEC x.163
fax 506-453-9470

/GEMTEC Limited <http://www.gemtec.ca>
/191 Doak Road
Fredericton, NB, Canada
E3C 2E6

-------------- next part --------------
Skipped content of type multipart/related