Faster ADO or ODBC API ?

Dear Friends

Please let me know which method is faster to access data from Database.
ADO or ODBC API ?

Thaks in advance
Ravi

[nagamalli]

Odbc api is faster than ado


mnmrao

[TeddyF]

Depends on what data source you are accessing, but for the most part ADO (used in conjuction with OLE DB) is very fast. I have tested the two options you mentioned with MS Access and SQL Server, and in both instances, I find perfomance to be a lot better with ADO. But let's see what others have to say about it...

I agree ODBC is faster