topic oledb oracle connection shows decimals ,00 in QlikView https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195573#M714715 <HTML><HEAD></HEAD><BODY><P>When I make an oledb connection to an oracle database decimals (,00) are added to numeric values (odbc does not). Is there a possibility to avoid this?</P><P>odbc</P><UL><LI>id</LI><LI>01</LI><LI>02</LI><LI>03</LI></UL><P>oledb</P><UL><LI>id</LI><LI>01,00</LI><LI>02,00</LI><LI>03,00</LI></UL><P>thanks!</P></BODY></HTML> Fri, 09 Jul 2010 11:00:47 GMT 2010-07-09T11:00:47Z oledb oracle connection shows decimals ,00 https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195573#M714715 <HTML><HEAD></HEAD><BODY><P>When I make an oledb connection to an oracle database decimals (,00) are added to numeric values (odbc does not). Is there a possibility to avoid this?</P><P>odbc</P><UL><LI>id</LI><LI>01</LI><LI>02</LI><LI>03</LI></UL><P>oledb</P><UL><LI>id</LI><LI>01,00</LI><LI>02,00</LI><LI>03,00</LI></UL><P>thanks!</P></BODY></HTML> Fri, 09 Jul 2010 11:00:47 GMT https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195573#M714715 2010-07-09T11:00:47Z oledb oracle connection shows decimals ,00 https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195574#M714716 <HTML><HEAD></HEAD><BODY><P>I want to avoid this ,too.</P></BODY></HTML> Mon, 16 May 2011 02:23:43 GMT https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195574#M714716 2011-05-16T02:23:43Z Re: oledb oracle connection shows decimals ,00 https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195575#M714717 <HTML><HEAD></HEAD><BODY><P>We encountered this problem ourselves &amp; finally came up with a fix. OLE is much more sensitive to data types than ODBC, so you need to match the format exactly.</P><P></P><P></P><P><A class="loading active_link" href="http://stackoverflow.com/questions/7920637/convert-a-string-date-into-datetime-in-oracle">http://stackoverflow.com/questions/7920637/convert-a-string-date-into-datetime-in-oracle</A></P><P></P><P>I realize this is an old post, but hope it helps somebody.</P></BODY></HTML> Thu, 04 Apr 2013 23:11:07 GMT https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195575#M714717 2013-04-04T23:11:07Z Re: oledb oracle connection shows decimals ,00 https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195576#M714718 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>i know this is an old post, but has anyone an solution for this problem. </P><P></P><P>thanks a lot </P></BODY></HTML> Wed, 24 Apr 2013 09:52:05 GMT https://community.qlik.com/t5/QlikView/oledb-oracle-connection-shows-decimals-00/m-p/195576#M714718 2013-04-24T09:52:05Z