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:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 9:39 AM > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > 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. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
