[mapguide-users] RE: Problems with ODBC Connection to Foxprodatabase

[Dave Wilson]

No that is an old email. Various ODBC connections are supported. The
only limitation with Foxpro is trying to find a driver for the version
you have. Microsoft has kindly stopped making a driver available.

Regards,
Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of martijni
Sent: Monday, June 11, 2007 4:04 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] RE: Problems with ODBC Connection to
Foxprodatabase


So when you want to make connection with the .dbf's (foxpro) you have to
import them in Acces and than make the ODBC connection instead of using
the
dbf connection string: Driver={Microsoft dBASE Driver
(*.dbf)};DriverID=277;Dbq=c:\mydbpath;

I'm correct?



Dave Wilson-3 wrote:
> 
> Unfortunately at this time ODBC is only working with MS Access.
>  
> Dave
> 
>   _____  
> 
> From: Chris White [mailto:chris.white at keytraffic.com] 
> Sent: Wednesday, April 26, 2006 9:39 AM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] Problems with ODBC Connection to Foxpro
> database
> 
> 
> 
> Hi,
> 
>  
> 
> I'm attempting to establish a connection to a Foxpro database using
> Autodesk MapGuide Studio.
> 
> I've created a system dsn and created connection with Studio however
> when I press test connection I get the following error:
> 
>  
> 
> System.Net.WebException: The remote server returned an error: (559)
> MgFdoException.
> 
>    at
>
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetReque
> stToString(Operation operation)
> 
>    at
>
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
> resourceId, String provider, String connectionString)
> 
>    at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
> 
>    at
>
Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.b
> uttonTestConnection_Click(Object sender, EventArgs e)
> 
>  
> 
> After reading other posts on this matter I logged onto the mapagent
and
> used the TestConnection functionality:- This time I get the following
> error:
> 
>  
> 
> 
> An exception occurred in FDO component. RDBMS: 
> 
> 
> An exception occurred in FDO component. RDBMS: Exception occurred in
> method MgFdoConnectionManager.Open at line 840 in file
>
c:\build_tux_area\mgdev\server\src\common\manager\FdoConnectionManager.c
> pp
> 
>  
> 
> Any ideas?
> 
>  
> 
> Thanks
> 
>  
> 
> Chris
> 
> Chris White
> Software Architect
> 
>   _____  
> 
>  
> 
> Key Traffic Systems Ltd.
> 
> Ardencroft Court
> Ardens Grafton
> Alcester
> Warwickshire
> B49 6DP
> Main: +44(0)8451 303040
> Fax: +44(0)8451 303141
> Mailto: chris.white at keytraffic.com
> <mailto:%20chris.white at keytraffic.com> 
> Web: www.keytraffic.com <http://www.keytraffic.com/> 
> 
>  
> 
> This e-mail & any attachments are intended only for the use of the
> person(s) to whom it is addressed. It may contain information that is
> privileged and confidential within the meaning of applicable law. If
you
> are not the intended recipient, please contact the sender as soon as
> possible by return mail or Tel +44 (0) 8451 303040. The views
expressed
> in this communication may not necessarily be the views held by Key
> Traffic Systems Ltd.
> 
>  
> 
>  
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/Problems-with-ODBC-Connection-to-Foxpro-database-t
f1512542s16610.html#a11057949
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users