>>I counld try on a WinNT4 box if that would make a difference.
>
>You'll just have to try it, because I haven't. Easy enough to test, though.
>
>> Is there any way to install just the VFP OLEDB provider without all of VS.NET?
>
>You can install any OLE DB provider by copying it to the directory of your choice(prog files\common\system\ole db\ is the default), then registering it with regsvr32.exe.

I was able to intsall and run on a WINNT4 box with no problem. The new support for stored procedures is great! Thanks for your help.

BTW, is there any documentation or help file for the VFP OLE DB provider yet? I did notice the default setting for SET ANSI is 'ON' and I believe SET DELETED was 'ON' by default also. What would be the appropriate way to change these environment setting if need be? Also, I ran a test query against a table with an integer primary key e.g. "SELECT * FROM table WHERE table.pkey = 100" and it seemed as though a table scan was performed instead of using the Pkey INDEX. I don't suppose there's a way to view the optimization plan for a query ran through the OLE DB provider?

In any case, VFP7 as a whole and the new OLE DB provider look VERY promising. It looks like the folks on the Fox Team have delivered a superior product once again!


Thanks