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

[martijni]

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-tf1512542s16610.html#a11057949
Sent from the MapGuide Users mailing list archive at Nabble.com.