>>>I have a msdn subscription
>>>no I want to explore using sqlserver with my vfp9.2 and I am wondering which SQLserver i should download
>>>win7/64
>>>
>>>thanks
>>
>>I've installed SQL Server 2012 Developer's edition (I also have SQL Server 2008 R2 Developer Edition SP1 installed). Both seem to work fine with VFP9. If you want to get the latest and the greatest, try SQL Server 2012.
>I want the simplest! i am a newby :-)
>
>also what do I need to do to access it from vfp (which is 32bit) any instructions available anywhere for a gringo (when it comes to SQL server)
>thanks
In our applications we're using DSN we set up using odbcad32.exe from Windows\sysWow64 folder. Then we're using sqlconnect and sqlexec functions to manipulate SQL Server data. We're also using technique similar to shown by Vlad G FAQ to make SPT cursor available and operate with it after that as a local view.
Hovewer, you can also try using Cursor Adapter.
If it's not broken, fix it until it is.
My Blog