ODBC vs OLEDB



Hi All,

I have confusion about the conectivity from ASP to sqlserver database using
ODBC and also using OLEDB.

Which one is faster and what are the advantages/disadvantages of both. What
is the internal difference between these two ways of connectivity.

Please help me. Thanks in advance.

-- Vasanth Kumar


.



Relevant Pages

  • Re: Migrating to OLEDB
    ... Certainly OLE DB is extremely flexible and I certainly understand that the ... in making a decision to use OLE DB over ODBC for a "typical" application. ... I am presently grappling with problems with OLEDB in our own application (an ... request a Forward-Only, Static, Keyset Driven, or Dynamic cursor type ...
    (microsoft.public.data.odbc)
  • Re: Migrating to OLEDB
    ... Certainly OLE DB is extremely flexible and I certainly understand that the ... in making a decision to use OLE DB over ODBC for a "typical" application. ... I am presently grappling with problems with OLEDB in our own application (an ... request a Forward-Only, Static, Keyset Driven, or Dynamic cursor type ...
    (microsoft.public.data.oledb)
  • Re: Migrating to OLEDB
    ... See 30 well-tested and real OLEDB examples ... In our tests the ODBC ... to have LOTS of features and to support ... >> YCY> Specifically, SQL Server and Oracle providers are faster than ...
    (microsoft.public.data.odbc)
  • Re: Migrating to OLEDB
    ... See 30 well-tested and real OLEDB examples ... In our tests the ODBC ... to have LOTS of features and to support ... >> YCY> Specifically, SQL Server and Oracle providers are faster than ...
    (microsoft.public.data.oledb)
  • Re: Migrating to OLEDB
    ... OLEDB has the same level of performance with ODBC. ... > YCY> Specifically, SQL Server and Oracle providers are faster than ... An OLEDB provider provides more features than its ...
    (microsoft.public.data.odbc)