VISUAL FOXPRO ODBC DRIVER PROBLEM

[CherryBlossom]

In the past, I used Microsoft Visual FoxPro Driver v6.00.8167.00 to link to DBF files (Quote It version 2.62). I recently upgraded Quote It Version 2.62 to Version 7.0. Since the upgrade, Microsoft Visual FoxPro Driver v6.00.8167.00 is no longer supported. I can't see these files or tables anymore. We would like to be able to link to tables because we had several reports written with Crystal Report. Is there a latest Visual FoxPro version that's available? If yes, where can I download or purchase it? Or is there another option to link to these tables. I appreciate your feedbacks. I'm confident that all feeback would be helpful. Thank you.

 

[craigber]

There is no update to the VFP ODBC driver. You can use the OLE DB Provider, available for free at

http://www.microsoft.com/downloads/...58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[CherryBlossom]

Thank you for your feeback Craigber!

I installed the OLE DB Provider for Visual FoxPro, but it's still not working. Is it required to do some configuration?

Cherry

 

[craigber]

The OLEDB Provider works differently than ODBC. You'll need to change the connection information in Crystal Reports

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[CherryBlossom]

Craigber, Thank you very, very, very much. You're a lifesaver! I'm able to see the tables now. Thank you again.

Cherry