Re: OLE DB driver with Interbase

Did you find any improved performance (mainly SELECTS) with OLE DB drivers
as compared to ODBC?

No, I have never made that comparison.
I suspect to be fair, I would have write in pure OLE DB as ADO comes with
its own baggage which I dont believe is huge but nevertheless does
contribute.
I have seen an OLE DB template library and that seem attractive to program
in.
I would also have to make sure that OLE DB was native anmd not piggybacking
on top of ODBC drivers.

Stephen Howe


.

Relevant Pages

  • RE: Connection from ASP- ODBC vs. SQLOLEDB
    ... script, ADO is preferable. ... ODBC is an API for database access that's both a formal and a de facto ... call-level interface standard by American National Standards Institute ... OLE DB ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: ADO
    ... ADO is the programming interface to ODBC, ... the drivers, your assumption is correct. ... All of the above 4 programming interfaces can communicate with ODBC and OLE ...
    (microsoft.public.sqlserver.server)
  • Re: Samplclnt example in MDAC 2.8: My Story
    ... I was incorrect when I stated that ODBC as a whole is deprecated. ... ODBC provider for OLE DB is deprecated; ... > | compiler errors. ...
    (microsoft.public.data.oledb)
  • Re: Geschwindigkeit von ADO
    ... nur um das noch mal klar zu stellen: Man kann/darf ADO nicht mit ODBC ... Datenzugriffsmechanismen stecken im OLE DB bzw. ODBC Treiber. ... Fall mit einem ADO Objekt zugreifen. ...
    (microsoft.public.de.fox)