Depending on how you wrote your program, you may need to rewrite or it could be as easy as creating remote views to SQL Server. Commands such as SEEK, LOCATE, SET FILTER, etc won't work with SQL Server tables.
http://www.hentzenwerke.com/catalog/csvfp.htm will get you started even though it is for an older version of SQL Server. You can buy the ebook and be reading today.
>HelloCommunity.
>I Just converted all my foxpro tables to SQL tables.
>but i was wondering if anyone could point me to a guide that would let me connect my foxpro to use connect to the SQL sever and use the SQL severs, thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer