topic ODBC VS OLEDB Connectivity in QlikView https://community.qlik.com/t5/QlikView/ODBC-VS-OLEDB-Connectivity/m-p/190176#M1280958 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P style="text-align: left">If OLE DB driver is available it should be used ahead of an ODBC connection.The use of OLE DB negates the need for setting up an ODBC connection. OLE DB simply requires one setup step within QlikView.</P><P style="text-align: left">ODBC is Open Data Base Connectivity, which is a connection method to data sources.It requires that you set up a data source ( DSN) using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.So it is user friendly</P><P style="text-align: left">But OLEDB is the successor to ODBC, a set of software components that allow a "<STRONG>front</STRONG> <STRONG>end</STRONG>" such as GUI based on VB, C++, Access or whatever to connect with a back endsuch as SQL Server, Oracle, DB2, mySQL etc. OLEDB components offer much better performance than the older ODBC.</P><BR /><BR /></BODY></HTML> Thu, 28 Apr 2011 07:03:59 GMT Anonymous 2011-04-28T07:03:59Z ODBC VS OLEDB Connectivity https://community.qlik.com/t5/QlikView/ODBC-VS-OLEDB-Connectivity/m-p/190175#M1280957 <HTML><HEAD></HEAD><BODY><P>Generally which type of connectivity is recommended when you connect a qlikview application to a database:</P><P>ODBC or OLEDB.</P><P>Note: The necessary setup for both are available.</P><P>1. Whcih would give a better performance and provides a secured mechanism for extracting?</P><P>2. What are the advantages and disadvantages of both?</P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/ODBC-VS-OLEDB-Connectivity/m-p/190175#M1280957 2026-01-26T18:19:17Z ODBC VS OLEDB Connectivity https://community.qlik.com/t5/QlikView/ODBC-VS-OLEDB-Connectivity/m-p/190176#M1280958 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P style="text-align: left">If OLE DB driver is available it should be used ahead of an ODBC connection.The use of OLE DB negates the need for setting up an ODBC connection. OLE DB simply requires one setup step within QlikView.</P><P style="text-align: left">ODBC is Open Data Base Connectivity, which is a connection method to data sources.It requires that you set up a data source ( DSN) using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.So it is user friendly</P><P style="text-align: left">But OLEDB is the successor to ODBC, a set of software components that allow a "<STRONG>front</STRONG> <STRONG>end</STRONG>" such as GUI based on VB, C++, Access or whatever to connect with a back endsuch as SQL Server, Oracle, DB2, mySQL etc. OLEDB components offer much better performance than the older ODBC.</P><BR /><BR /></BODY></HTML> Thu, 28 Apr 2011 07:03:59 GMT https://community.qlik.com/t5/QlikView/ODBC-VS-OLEDB-Connectivity/m-p/190176#M1280958 Anonymous 2011-04-28T07:03:59Z