OLEDB vs ODBC

ODBC Connectivity, ELFs , Windows API etc.

Moderators: Phil Winkler, Graham Smith, Pete Tabord

OLEDB vs ODBC

Postby Graham Smith » Thu Nov 19, 2015 1:06 pm

Many moons ago, MS developed OLEDB as a replacement for ODBC. But ODBC didn't roll over and die the way MS hoped it would. So now, we have two ways to connect to a SQL database.

If you are writing a C++ or Java application, there are some technical reasons why you may choose OLEDB. But for us mere mortals, who only want to connect Ffenics to a SQL database, what differences are there in function and performance?

I've experimented with both in the past and really have no idea. I do know that there were cases where one would work and the other would not, but I have no idea why.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 
 

Return to Advanced

Who is online

Users browsing this forum: No registered users and 2 guests