system
September 7, 2007, 10:20am
1
Hi,
I am about to create a Universe and Database is SQL Server 2005. All the users use Desktop Intelligence. DB server and BOXI server is in another country. if users are in country A then both the DB and BO Application server is in Country B. I have following doubts.
OLE DB or ODBC is better to create the DB connection
Which is faster in this case?
Thanking you in Advance.
kuruvi_r (BOB member since 2007-04-03)
system
September 9, 2007, 5:53am
2
Doing a Search using keywords like 'OLEDB vs ODBC would have fetched past discussions
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
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)
(BOB member since 2005-07-18)