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.
Below are some links 'differnce between oledb and odbc':
[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.
Hope this help you.