Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
oledb is used for relational and non relation database( like sql server,oracle,flatfiles etc)
odbc is used for relational database ( sql server ,oracle)
here my question is both having chance to connect sql server and oracle database
then what is the difference between these 2 connectors while connecting to sql server and oracle database
if same then why should we have both
oledb is 3tier and odbc is 2 tier architecture ?
ODBC is Open Data Base Connectivity, which is a connection method to data sources and other things. It requires that you set up a data source, or what's called a DSN using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.
OLE is Object Linking and Embedding. OLEDB is partly distinguished from OLE itself, now called "automation".
OLEDB is the successor to ODBC, a set of software components that allow a "front end" such as GUI based on VB, C++, Access or whatever to connect with a back end such as SQL Server, Oracle, DB2, mySQL etal. In many cases the OLEDB components offer much better performance than the older ODBC.
1. OLEDB is faster than ODBC
2. OLEDB is dynamic connection it doesn't require any connection instance to be created in the Qlikview server.
The main difference is that the OLEDB connection string is embedded in the QlikView script and no external connection file is required. ODBC requires a connection to be defined on the machines that connect and load data. So when an app using odbc is deployed to the server, you must have an identically named odbc DSN on the server.
For simplicity in maintaining connections oledb would be my preference.
That said some databases are not included in the QlikView oledb connection list, so for these odbc is the only option.
If you just use multiple copies of QV desktop with odbc drivers, each user must have identically named dsns for the data connection.
oledb is 3 tier or 2 tier?
The differences between ODBC and OLE DB has already been highlighted above, no need to repeat it here. To answer your other question, SQL Server and Oracle DB are major players in the database world, and as such need to provide various means to access their system, hence having both, ODBC and OLE DB.
Regarding to the tier, it's about the theoretical design (not to be confused with the actual architecture). It only says that OLE DB may sit on top of ODBC as a wrapper.