Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using OLEDB Provider with VFP 6 Database
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01009871
Message ID:
01009901
Views:
9
>I'm current working on a ASP.NET application that uses a VFP 9 database as the backend. I also need to access data from a VFP 6 database. Unfortunately, I cannot upgrade the VFP 6 database, because the application that it's used for does not support VFP 9.
>
>I have a couple of questions about this cross version data access.
>
>1) Can I use the VFP 9 OLEDB provider to read data from the VFP 6 database or would I have to stick with ODBC?


Yes, you can.

>2) Can I use VFP 6 to insert records directly (using native VFP code rather than via ODBC or OLEDB) into the VFP 9 tables without messing it up?

It depends on what kind of VFP9 tables we're talking about. If VFP9 tables use any new data features introduced after VFP6 ( like AutoInc fields, varchar fields, e.t.c. ) than you wouldn't be able to open such tables in VFP6.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform