FoxPro with SQlServer2005: ADODB or ODBC  
Author Message
camsambora





PostPosted: Visual FoxPro General, FoxPro with SQlServer2005: ADODB or ODBC Top

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  
 
 
Alex Feldstein





PostPosted: Visual FoxPro General, FoxPro with SQlServer2005: ADODB or ODBC Top

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.


 
 
CetinBasoz





PostPosted: Visual FoxPro General, FoxPro with SQlServer2005: ADODB or ODBC Top

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).