Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question