Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked VFP Database
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00614913
Message ID:
00615089
Views:
24
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform