sql server programming:

Rey,

Check if the article "HOWTO: Add a FoxPro Database to SQL Server as a Linked
Server" at http://support.microsoft.com/default.aspx?scid=kb;en-us;199131is
helpful.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

[quoted text, click to view]
SQL server...

In news: 6710491B-1196-4719-8A70-DD75791DC2F3@microsoft.com,
[quoted text, click to view]

Hi Rey,

You'll get better answers if you post to a Visual FoxPro group on this same
news server.

You haven't said which version of VFP you are using. You can connect via
ODBC and create views to your SQL Server data or you can use SQL
Pass-through. Views work pretty much like native VFP tables. You can also
use ADO via OLE DB.

For some books on this subject see www.hentzenwerke.com.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com