OLE DB vs ODBC when creatinf Universe connection

[system]

Doing a Search using keywords like 'OLEDB vs ODBC would have fetched past discussions
Here are some

120×120 10.4 KB

I’m moving into a SQL Server environment for the first time in the near future. What are the advantages of having OLEDB connections compared to ODBC? What’s the easiest way of maintaining client connectivity for say 30 clients (i.e. the equivalent to TNSNAMES)? Are there any common pitfalls that I should be aware of? Many thanks. anorak (BOB member since 2002-09-13)

120×120 10.4 KB

Hi! When creating a new connection for our newly installed BusinessObjects XI R2 using ODBC we were getting errors saying; [Data source name not found and no default driver specified] The drivers have been created and works fine when testing the connection outside Business Objects. By changing to OLE DB we got rid of that problem. What I would like to know is if there is a particular reason to use ODBC or OLE DB??? We are using SQL Server 2005 and BusinessObjects XI R2. Any ideas why the O…

.

---

haider (BOB member since 2005-07-18)