Mike,

Hmmm, sounds like a SQL Server bug (why would linked servers not respect the ODBC settings?) I wish I had something more to offer, but when the underlying linked server...

You can suppress the deleted records in ODBC by configuring the ODBC driver for VFP. Try going to Start->Control Panel->Administrative tools->Data Sources (ODBC).

Select the Visual FoxPro Tables from the list...

Hi Mike,

I've never had much luck with the VFP OLEdb provider when it comes to SQL Server linked server. I suggest that you use the ODBC driver instead. For more...

Nice article that I plan on using when someone looks at me with a blank stare when I try to explain the difference between static and dynamic queries.

The application I...

Where I work we designed our application from the ground up to use SQL Security. Even though at this time all users connect to a domain control and could use...