Can the MS Visual Foxpro ODBC driver create a FoxPro 2.5 database? 
Author Message
 Can the MS Visual Foxpro ODBC driver create a FoxPro 2.5 database?

I am trying to provide legacy support for some of our clients who
depend on our previous system's ability to export data in FoxPro 2.5
DBF format. The current system is written in VB6, using ADO for
database connectivity. I figured out how to connect to the VFP ODBC
driver and create a table, but the table can't be opened by Fox 2.5;
apparently MS changed the table format a bit for Visual FoxPro and
this is what's created.

The MS Knowledgebase references a "version" connection parameter for
the driver, but it does not list any valid values. I've tried "2.5",
"FoxPro 2.5" and "ABCD", but the table format never changes, and the
driver never complains (come on, version "abcd"?!).

So, does anyone know if it's even possible to create a table in the
Fox 2.5 format through ODBC using Microsoft's VFP driver? BTW, the
driver version I have is 6.1.8629.1, using MDAC 2.7.

Thanks in advance,

Tue, 16 Nov 2004 21:28:46 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Need help creating Fox 2.5 table via MS Visual FoxPro ODBC driver

2. Visual Basic 3.0 for Windows and Foxpro 2.5 for Windows database

3. Database compression routine for Foxpro 2.5 database

4. [ODBC Visual FoxPro Driver]Invalid argument value

5. [ODBC Visual FoxPro Driver]SQL: Statement too long.

6. [ODBC Visual FoxPro Driver]Invalid argument value

7. ODBC driver error with Visual Foxpro Version 9

8. Problems with FoxPro/Visual Basic 6 with ADO 2.5

9. How can i use foxpro 2.5 files with visual basic

10. Create a Foxpro 2.5 table

11. Compacting a Foxpro 2.5 database

12. open foxpro 2.5 database


Powered by phpBB® Forum Software