oledb and odbc

Results 1 to 4 of 4

Thread: oledb and odbc

  1. #1
    Join Date
    Dec 1969

    Default oledb and odbc

    I want to know the difference between oledb and odbc. which one is faster and why.<BR>why dsn is not that much useful compare to ole db

  2. #2
    Join Date
    Dec 1969

    Default SQLOLEDB is specifically for SQL Server

    ...Because of that, it has performance enhancements built in to avoid the normal overhead of communcating through ODBC.

  3. #3
    Dave Purscell Guest

    Default RE: SQLOLEDB is specifically for SQL Server

    There is an excellent discussion of the two elsewhere on this site. I think I ran across it while following a link about DSNless connections. Here it is...<BR><BR>http://www.4guysfromrolla.com/webtech/070399-1.shtml

  4. #4
    Join Date
    Dec 1969

    Default BUT - OLEDB is available for other databases

    the question was NOT focused solely on SQLOLEDB - there&#039;s also a provider for access and one for FoxPro - there may also be others.<BR><BR>OLEDB is actually the windows-native Data Access layer. ODBC for OLEDB-connected RDBMSes is an extra layer abstractin the OLEDB functionality. DSNs add a further step to the process<BR><BR>there&#039;s a discussion of this on http://www.infinitemonkeys.ws/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts