OLE DB Providers vs ODBC Drivers

general discussion
1

What’s the difference between using an OLE DB Providers or ODBC Drivers to connect a SQL Server database?

Besides, it seems that OLE DB Providers option is not present at BO 6.0 for access to SQL Server. Is this right?

Thanks,

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

2

Did you do a search for OLE or ODBC on BOB or on www.microsoft.com?

Andreas :de: (BOB member since 2002-06-20)

3

I did a search before but using OLE DB, not OLEDB. Now I’ve found more issues (like this for instance OLEDB vs ODBC). It seems that, basically, OLEDB connections are faster than ODBC.

Anyway, and from the point of view of the BO applications, there is not difference between using Designer and Reporter with OLEDB or ODBC, right? you see the same functions, operators, etc….

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

4

The main advantage using OLEDB, is than you haven’t to deploy DSN on the clients. The server name and connection parameters are stored in the connection and in the repository.

The problem is than you can’t currently use OLEDB for accessing the BO repository with Enterprise 6, just ODBC

jp.golay :switzerland: (BOB member since 2002-06-17)

5

Thanks Jean-Philippe,

By the way, I’ve seen in this topic that OLEDB is supposed to be included in 6.1. Do you know something about that?

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

6

OLEDB with Version 6 :expressionless: would have been interesting for me too - but I could not find OLEDB even mentioned in 6.1 Readme or 6.1 PAR … so I think that our hope for OLEDB Support with BO6 is not justified… :nonod:

Wolfgang from vienna

Wolfgang Bidner :austria: (BOB member since 2002-08-30)