FoxPro with SQlServer2005: ADODB or ODBC

Hy! I'm using Visual FoxPro8.0 (forms) with SQLSERVER2005 (data). I want to use cursoradapter object but I don't know what DataSourceType property should be: ADO or ODBC. Which is the best for SQLServer2005 Thank you.

Visual FoxPro2

Both will work for you. Some people say that OleDB is a little faster, but I have not seen much difference. OleDB is newer, more powerful, and more complex. In any case, you could use a combination of both. For simple queries, you will not see a diifference and you will end up with a VFP cursor in any case.

I use OleDB with ASP.NET as it is more optimized in the NET Framework. In VFP I tend to use ODBC as it is easier to use. The important issue is to know both so you are prepared to handle any case. Your choice.

Use SQLNCLI OleDb driver, especially if you have new xml datatype. VFP fails to return it right with ODBC (but I don't know if that's really VFP problem or NativeClient's ODBC driver).