Using VC with Visual Foxpro Database 
Author Message
 Using VC with Visual Foxpro Database

Easiest line of attack would probably be to use CRecordSet's
to connect via OLE/DB or ADO objects to an ODBC defined
DSN for the database. The VC database wizard can generate
much of the basic code if you're completely lost in this area but
be aware that it produces far from optimal solutions.

The only really serious problem you will encounter is that the
ODBC driver for Visual FoxPro is a little strange IMHO in that
it seems to assume that you're using VFP as the programming
environment and doesn't therefore provide a complete support
for all the functions you might otherwise have.

A suggestion made recently in one of the Borland ng's for this
(applied to BCB and Delphi) was to use a 3rd party engine to
access the VFP database. This may be a better choice, and
you can still use the normal VC development wizards and the
rest for the normal development.  For alternative engines try
searching http://www.*-*-*.com/ for "FoxPro" in the BDE and
borland.public.delphi.database.desktop (or BCB) ng's.

A common starting point for this for Borland types is;
however want to consider using VFP itself to develop part
of your application. I haven't used it for years, but you should
be able to integrate VFP/VC to provide a better solution than
either one alone....

"If you think you know the answer,
then you don't understand the question !"

> I used to program utilities in VC, but I am now tasked to do an
> application using Visual Foxpro Database.   Kindly give me  guidelines
> how??

Tue, 23 Jul 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Database settings -- Visual C++ used with Visual FoxPro database

2. Visual FoxPro, Visual C++ and database settings

3. Accesing FoxPro Database from Visual C

4. ADO Object Command and the method CreateParameter to add a variant in a Visual FoxPro database

5. DLLs needed for opening FoxPro database using DAO

6. Connecting to Visual FoxPro datasource using remote datasource control (msrdc32.ocx)

7. Visual FoxPro and Visual C++

8. How to open access database using vc dotnet

9. Converting FoxPro databases to Access?

10. Convert FoxPro databases to Access?

11. Help with Open exclusive through ODBC with Foxpro database

12. Using visual database tools


Powered by phpBB® Forum Software