Error Linking to VFP Tables

[Danny]

Running Access 2003, trying to link to Visual FoxPro tables through ODBC, I
get this error:

Could not execture the query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table.(#123)

The ODBC data source is using the MS VFP driver, referencing a database
rather than a free table directory.

Help...

 

[Cindy Winegarden]

Hi Danny,

Over time new data features have been added to FoxPro tables. Features added
through VFP6 are compatible with the FoxPro and Visual FoxPro ODBC drivers.
Features added in VFP7 and above are only compatible with OLE DB, although
tables created with VFP7+ that don't use any of the new features will still
be compatible with ODBC.

To access data via OLE DB you will need to write code to use ADO recordsets.
You can't import or link to the tables directly.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

 

[Danny]

Hi Cindy, and thanks for the reply. In all that I was reading, I was
understanding that this connection had to be done through code, not through
the link table wizard.

I've just looked for some code samples and can't find any; any ideas would
be helpful.

Ciao.

Hi Danny,

Over time new data features have been added to FoxPro tables. Features added
through VFP6 are compatible with the FoxPro and Visual FoxPro ODBC drivers.
Features added in VFP7 and above are only compatible with OLE DB, although
tables created with VFP7+ that don't use any of the new features will still
be compatible with ODBC.

To access data via OLE DB you will need to write code to use ADO recordsets.
You can't import or link to the tables directly.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

Running Access 2003, trying to link to Visual FoxPro tables through ODBC,
I
get this error:

Could not execture the query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table.(#123)

The ODBC data source is using the MS VFP driver, referencing a database
rather than a free table directory.

Help...

 

[Cindy Winegarden]

Hi Danny,

Yes, accessing data via OLE DB and ADO requires code and can't be done
through the Link Table Wizard.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx