Need help creating Fox 2.5 table via MS Visual FoxPro ODBC driver 
Author Message
 Need help creating Fox 2.5 table via MS Visual FoxPro ODBC driver

I need 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 new system is written in VB6, using ADO for database connectivity.
I can create a table via the VFP ODBC driver, but the table can't be
opened by Fox 2.5; apparently MS changed the table format a bit for
Visual FoxPro.

The MS Knowledgebase refers to 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,
Ugh!



Sat, 27 Nov 2004 21:50:07 GMT  
 Need help creating Fox 2.5 table via MS Visual FoxPro ODBC driver
Just a WAG, but have you tried 'FOX2X' (as in COPY TO [...] TYPE FOX2X)?

 - Rush



Quote:
> I need 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 new system is written in VB6, using ADO for database connectivity.
> I can create a table via the VFP ODBC driver, but the table can't be
> opened by Fox 2.5; apparently MS changed the table format a bit for
> Visual FoxPro.

> The MS Knowledgebase refers to 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,
> Ugh!



Sat, 27 Nov 2004 22:35:26 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Can the MS Visual Foxpro ODBC driver create a FoxPro 2.5 database?

2. Create a Foxpro 2.5 table

3. MS Visual Basic -> MS Access via ODBC

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. problem with odbc driver for oracle 2.5

9. Need ODBC driver for FoxPro data

10. Packing a FoxPro table via ODBC.net from VB.net

11. VBS accessing foxpro db/tables via odbc

12. FoxPro 2.5 Error opening Table

 

 
Powered by phpBB® Forum Software