Hi

I need to develop an application that connects to SQL Server 2005, from my VFP 9 SP2 application: does anyone know of an already built VFP application that I can download/look at in order to glean how best to achieve this?

In summary, all of the data tables are held within SQL 2005, my VFP application needs to be able to access this data, and perform the usual updates/amends/inserts etc. Note, I'd anticipate doing most of the queries within VFP for the time being (rather than native stored procedures with SQL 2005), unless of course I can write the stored procedures with SQL 2005 to do this for me. If anyone knows of a good example of SQL 2005 stored procedure queries then I'd also be grateful for that too.

Regards