Re: Q: what is the relation between DB-Lib, OLE-DB, and ODBC?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: leiyang (nospam_at_yahoo.com)
Date: 01/20/05 

Date: Wed, 19 Jan 2005 22:36:14 -0500

Hi,
    try OleDBPro at www.udaparts.com. It is simple and fast with lots of
samples.

"johndoe1" <blam@blam.com> wrote in message
news:opskvr3colc00ccp@lbelyakov-d.daq-l.net...
> On Wed, 19 Jan 2005 23:36:16 +0000 (UTC), Erland Sommarskog
> <esquel@sommarskog.se> wrote:
>> I had reason some time ago to make a choice between ODBC and OLE DB
>> to replace a module that I have in DB-Library. My choice fell on
>> SQLOLEDB, because I had a vague feeling that ODBC may be in for
>> deprecation earlier than OLE DB. Then again, if you use the bulk copy
>> interface in DB-Lib a lot, ODBC is good, because its BCP API is the
>> the same as DB-Lib's.
>>
>> Undoubtedly, the OLE DB API leads to verbose code,
> Yeah, euphemistically speaking <g>. I'd love to avoid this monstrosity,
> but it seems that db-lib is no longer an option... ODBC would be better
> too, but it's slower. So... OLE DB it is!
>
> Thanks for your help, Erland.
>
> PS. Btw, can you recommend any sources of decent sample code for this (OLE
> DB with MS Sql server), and also, while we're here, on writing extended
> stored procedures for the same platform. I perused the samples
> (perfunctory in the extreme) that come with the package and don't think
> they're sufficient. For example they use some sort of the server API
> (ODS?) whose reference is nowhere to be found. At least I couldnt --
> neither on CDs (VC and MSDN), nor online on Microsoft's site. The only
> link to it results in 404.
>
> PPS. Any good books on the same topic?

Relevant Pages

  • Re: Different empty_string/NULL handling under ODBC and OLE DB?
    ... NULL whereas empty string is stored as a space. ... When migrating from ODBC to OLE DB we get errors when inserting an ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Samplclnt example in MDAC 2.8: My Story
    ... It's funny how Microsoft appears to be pushing OLE DB hard, ... > people seem reluctant to abandon ODBC, and again, I've heard from ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: What is the faster way to insert/buck insert rows into SQL Server
    ... I would have said SqlClient would be the fastest--that or DBLib. ... Hitchhiker's Guide to Visual Studio and SQL Server ... code in C++ and used ODBC driver SQLBindParameter to bind the data in the ... OLE DB .Net ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Reading mm datasource
    ... If you don't specify one, it will probably try OLE DB first, then possibly ODBC. ... Doug's post helped me identify that the client has the odbc dbase driver ... Word is trying to connect using the OLE DB provider ...
    (microsoft.public.word.mailmerge.fields)
  • Re: DDE Access to Word using mde
    ... OLE DB is the method that Word 2002/2003 use by default - in fact, given the code you are using, I am pretty sure that when your Access code opens the word document in Word 2002/2003, Word will be using OLE DB rather than DDE to open the data source. ... So either the OLE DB connection is handling your dates and memos just fine, or I'm wrong and DDE is being used. ... ODBC should get your dates OK, but you would need to use switches in the Word fields to format them correctly. ...
    (microsoft.public.word.mailmerge.fields)