Hi Jeff...

>My question was not concerning the VFP data engine per se - I was refering to >the future ability to connect to a SQL Server 7.0 cube (within the Repository) >via ADO (or ADO/MD as MS refers to). I was just wondering if you had heard >anything about it and, if so, :

Thats not a future capability. You can do it today with the Microsoft Decision Support Tools (ADO MD, etc)..

>[1] Will native VFP controls will support ADO and ADO/MD collections as a >ControlSource.

I don't think so. If it were just a single value - then sure. Collections however, are a different beast. You can work with them in VFP, but as far as data binding goes, you will need to use a different UI - like VB.

>[2] Will the SQL Server 7.0 Repository support the VFP ODBC driver so that you >can create metadata cubes with VFP data (e.g. a VFP-Access-Excel-Text cube).

The VFP ODBC Driver has lots of issues regarding ADO. I don't know if this will work. I for one would not count on it. At the least, there will probably be one or two nagging issues that would prevent you from using VFP Data. But, you are not out of luck.

You could use the Data Replication Services and replicate the data stored in VFP and store it in SQL Server.


>This is powerfull stuff. We, as FoxPro programmers, have alot of experience >with data and have provided some rather ingenious solutions for heterogeneous >data. I may take some heat for saying this, but SQL Server 7.0 can provide us >with an opportunity to REALLY do data in ways which are light years beyond the >native VFP data engine. This can give us a competitive edge over the army of >"data-unaware" programmers which has infected the market place.

Could'nt have said it better myself...