topic OLEDB or ODBC ? in QlikView https://community.qlik.com/t5/QlikView/OLEDB-or-ODBC/m-p/183331#M48642 <HTML><HEAD></HEAD><BODY><P>Wikipedia said:</P><P>OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing different types of data stored in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL.</P><P>I've used both conections and I didn't see any differences in performance, speed, etc.</P><P>Best regards.</P></BODY></HTML> Thu, 10 Dec 2009 23:16:27 GMT 2009-12-10T23:16:27Z OLEDB or ODBC ? https://community.qlik.com/t5/QlikView/OLEDB-or-ODBC/m-p/183330#M48641 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I've newbie questions about connexions on Databases (Oracle, SQL Server) with QlikView</P><P>1) I often have the choice between ODBC and OLEDB for the same database. What are the differences ? OLEDB seems to be more recent so I suppose it's better (in terms of speed?, functionnalities ?)??</P><P>2) I've read that OLEDB should be replaced by .Net drivers. Is QlikView already manage that kind of drivers ? Will it be managed in next release ?</P><P>Thanks for your help</P><P>Regards</P></BODY></HTML> Thu, 10 Dec 2009 21:03:56 GMT https://community.qlik.com/t5/QlikView/OLEDB-or-ODBC/m-p/183330#M48641 2009-12-10T21:03:56Z OLEDB or ODBC ? https://community.qlik.com/t5/QlikView/OLEDB-or-ODBC/m-p/183331#M48642 <HTML><HEAD></HEAD><BODY><P>Wikipedia said:</P><P>OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing different types of data stored in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL.</P><P>I've used both conections and I didn't see any differences in performance, speed, etc.</P><P>Best regards.</P></BODY></HTML> Thu, 10 Dec 2009 23:16:27 GMT https://community.qlik.com/t5/QlikView/OLEDB-or-ODBC/m-p/183331#M48642 2009-12-10T23:16:27Z