topic Re: what is difference between ODBC and OLEDB ..... in QlikView https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642258#M1085800 <HTML><HEAD></HEAD><BODY><P>OLEDB is the successor to the earlier ODBC. </P><P></P><P>I always use OLEDB in preference to ODBC.</P></BODY></HTML> Fri, 06 Jun 2014 10:22:47 GMT Anonymous 2014-06-06T10:22:47Z what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642257#M1085799 <HTML><HEAD></HEAD><BODY><P>actuvally a few days back i connected sql server throgh oledb in my system.........it's working.....and today i am try to connect sql server through odbc....it's connected and it's also working......then what is the diff b/n those two? </P></BODY></HTML> Fri, 06 Jun 2014 10:14:04 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642257#M1085799 d_koti24 2014-06-06T10:14:04Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642258#M1085800 <HTML><HEAD></HEAD><BODY><P>OLEDB is the successor to the earlier ODBC. </P><P></P><P>I always use OLEDB in preference to ODBC.</P></BODY></HTML> Fri, 06 Jun 2014 10:22:47 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642258#M1085800 Anonymous 2014-06-06T10:22:47Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642259#M1085802 <HTML><HEAD></HEAD><BODY><P>follow link</P><P><A href="http://sqlmag.com/sql-server/ole-db-or-odbc" title="http://sqlmag.com/sql-server/ole-db-or-odbc">http://sqlmag.com/sql-server/ole-db-or-odbc</A></P></BODY></HTML> Fri, 06 Jun 2014 10:27:33 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642259#M1085802 dinuwanbr 2014-06-06T10:27:33Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642260#M1085803 <HTML><HEAD></HEAD><BODY><P>Please read:</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion">http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion</A> and</P><P><A _jive_internal="true" href="https://community.qlik.com/message/437057#437057">http://community.qlik.com/message/437057#437057</A></P></BODY></HTML> Fri, 06 Jun 2014 10:37:45 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642260#M1085803 ThornOfCrowns 2014-06-06T10:37:45Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642261#M1085804 <HTML><HEAD></HEAD><BODY><P>It is very important to understand and test your preferred method of connection. One issue I have had previously is bit values in databases being returned differently. Some return them as 0 and 1, and others as 0 and -1. My advice is to pick your preferred method and stick with it.</P><P></P><P>Whilst Microsoft OLEDB was originally released as the successor to ODBC with intended improvements in functionality and performance, they have since back tracked and have actually removed the OLEDB provider for SQL 2014. They have also released information that ODBC can perform better than OLEDB.</P><P></P><P>Many developers automatically state OLEDB is "better" than ODBC as this was how it was described at the outset, but this view is not fully correct any more. There is more info on Wikipedia, specifically the 2 links in the References section ... <A href="http://en.wikipedia.org/wiki/OLE_DB" title="http://en.wikipedia.org/wiki/OLE_DB">OLE DB - Wikipedia, the free encyclopedia</A></P><P></P><P>flipside</P><P></P><P><BR /> </P></BODY></HTML> Fri, 06 Jun 2014 10:43:21 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642261#M1085804 flipside 2014-06-06T10:43:21Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642262#M1085805 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Sat, 07 Jun 2014 10:10:21 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642262#M1085805 d_koti24 2014-06-07T10:10:21Z Re: what is difference between ODBC and OLEDB ..... https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642263#M1085806 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Its very helpfull Doc</P></BODY></HTML> Tue, 26 Sep 2017 03:04:38 GMT https://community.qlik.com/t5/QlikView/what-is-difference-between-ODBC-and-OLEDB/m-p/642263#M1085806 Vishnu 2017-09-26T03:04:38Z