My first idea is to use ODBC. I used that technic in the past with Interbase and I had no problem. But it was on a local machine. But actually I can't configure the ODBC to establish the initial connection to SQL Server. I never used ADO so I know nothing about it and if it's could be a better choice neither.
Thanks,
Not necessarily. While the basic technologies used to connect to SQL Server are the same across multiple products, the specifics are different. From VFP you can connect two ways, ODBC or OLE-DB Those are the standard technologies. But inside VFP you can use Remote Views (RV), SQL Pass Through (SPT), ADO, or CursorAdapter (CA). If you want to use RV or SPT, you must use ODBC. ADO must use OLE-DB. CA can use either ODBC or ADO.
So, your question was properly placed in the VFP forum.
Have a nice day,
Normand