cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC vs OLE DB connection?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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_n...

Hope this help you.

Regards,

Deepti Bajpai

Answers (1)

Answers (1)

BasicTek
Active Contributor
0 Kudos

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