Skip to Content
avatar image
Former Member

ODBC vs OLE DB connection?

What are the pros and cons of using an ODBC vs OLE DB connection? I created both of these connections in designer pointing to the same database using MS SQL Server 2005. We are going to be re-pointing all of our Universes to use this new database and are trying to decide which connection to use. We are on XIR2 SP2 and are planning to upgrade to XI 3.1 soon. Are there any known issues or differences with this in XI 3.0 or 3.1?

Any response would be greatly appreciated.

Thanks,

Mike

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2008 at 09:14 PM

    Hi,

    Below are some links 'differnce between oledb and odbc':

    1]

    http://www.dotnetspider.com/forum/156042-ODBC-OLEDB-difference.aspx

    [In general, OLE DB provides a richer and more flexible interface for data access because it is not tightly bound to a

    command syntax (like SQL in the case of ODBC). As Microsoft points out:

    Whereas ODBC was created to access relational databases, OLE DB is designed for

    relational and non-relational information sources, including mainframe ISAM/VSAM

    and hierarchical databases; e-mail and file system stores; text, graphical, and

    geographical data; custom business objects; and more.

    ODBC on the other hand is a more established interface because it has been around longer; there are proven drivers

    and applications available in the market place. OLE DB is creating a better known presence, but consumer support is

    probably still considered limited. With the release of Windows 2000 Professional, OLE DB will be installed as part

    of the operating system. In Microsoft Office2000 all member applications will be OLE DB consumers. When these

    two major products ship, OLE DB will be much more ensconced in the marketplace.

    ]

    2]

    http://devlibrary.businessobjects.com/BusinessObjectsXI/en/en/BOE_SDK/boesdk_dotNet_doc/doc/boesdk_net_doc/html/CrystalEnterpriseReportPlugInLibrary252.html

    Hope this help you.

    Regards,

    Deepti Bajpai

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2008 at 12:36 AM

    My experience here only....

    While OLE DB is nice to use and is a more direct approach to connecting to a SQL DB, ODBC is easier to troubleshoot since the connections can be tested independently of the BO service/product.

    Regards,

    Tim

    Add comment
    10|10000 characters needed characters exceeded