>>>Since VFP 10 can run in 64bit -- is there a way to connect to a VFP 10 DBC with a 64bit ODBC driver? Is that something that is part of the whole thing?
>>
>>
>>VFP Advanced 64 bit use 64bit ODBC drivers only.
>>
>>MartinaJ
>
>Yes -- if I want to connect VFP to SQL then need the 64bit SQL ODBC driver
>....but I want to connect SQL to VFP -- so I need the VFP ODBC driver for 64bit??? And is there one?
Hi,
VFP ODBC/OLE DB driver is 32bit only.
If you want import VFP table to MSSQL from MSSQL:
- it's possible within SSIS package 32 bit. But safety is uploading VFP data from VFP to MSSQL.
- copy vfp table to fox2x format and use odbc driver "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)" - it's 64 bit.
MartinaJ