>>Does anyone have any thoughts on the implementation of a VFP linked database in SS? We have a client that is proposing this as a means to incrementally move their database.
>>
>>Thoughts, observations, personal experience, etc are welcome.
>
>Hi Wayne,
>
>We are using VFP linked server (OLE DB over ODBC) to access a few 2.6 tables from Sql Server. It looks like speed is the same as using ODBC to access the same table. After VFP OLE DB provider was released I tried VFP linked server with it and found out that it's much, much slower than OLE DB over ODBC.
Thanks for your insight - I will be sure to put that down on my list of things to check.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown