The VFP ODBC driver has not been updated since VFP 6. If you use any database features added after that, ODBC will fail.
>I'm trying to access a .dbc database on a Windows 64-bit machine. I can open some .dbc databases using VFP9 on my Windows7 64-bat machine. But database in particular will not allow my to use its tables. It gives me an error reading:
>"Connectivitey error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."
>
>I have tried to install a VFP ODBC driver using \Syswow64\ODBCad32.exe. It seemed to install ok. I added a path which points to the database I am attempting to use. However I still get the connectivitey error.
>
>Naturally, I must be able to access the database and its tables for ongoing work, and I am stumped.
>
>Thanks in advance for your helpful ideas!
>
>Gerry
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer