Why this is better

[sammy]

I heard that it is always good to use OLE DB instead of ODBC in ASP. But I could not figure out the reason for the same .Is it because of the error users get usually with ODBC. Someone kindly share your knowledge on this concept and help us envisage our knowledge in this.

[cyrus]

You are correct partly with respect to your idea of the error users get usually with ODBC. The error that user get in ODBC is normally because of the instability feature of ODBC. But this is not only the reason for preferring OLDB when compared with ODBC. In addition the enhanced feature available with OLDB rather than ODBC makes it to be a better choice among users.