mbarry


Hello! I'm looking to access a VFP database from an ASP.NET web application and I have a couple questions about the OLE DB data provider.

1) Can I use the latest VFP 9.0 OLE provider with a VFP 6.0 free table directory Should I expect any problems

2) Does the OLE DB provider have any dependencies on VFP E.g. could I install it on a machine without VFP and still be able to manipulate my data files

Thanks in advance!

- Matt




Re: A couple questions about the OLE DB data provider


Re: A couple questions about the OLE DB data provider

CetinBasoz

1) Yes you can and you should use VFPOLEDB driver.

2) Yes you can. Formerly it had dependancy on VFP license wise. Now it's publicly available.






Re: A couple questions about the OLE DB data provider

Cindy Winegarden

Hi!

Just to add to what Cetin said, the OLE DB data provider is fully backward compatible with all versions of Fox tables including those created with FoxPro for DOS.






Re: A couple questions about the OLE DB data provider

mbarry

Awesome. I really appreciate the help and I look forward to learning a few things about VFP. Thank you!



Re: A couple questions about the OLE DB data provider

CetinBasoz

You're welcome. BTW I suggest using ObjectDataSource, though it's not code free and you might need to skim chapters about using an ObjectDataSource, it gives you more control.



Re: A couple questions about the OLE DB data provider

mbarry

Thanks for the suggestion. I've used ObjectDataSource previously with my SQL Server projects, so I'm already familiar with the multi-tiered approach. It's definately the way to go.