oledb oracle connection shows decimals ,00

[#1]

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?

odbc

• id
• 01
• 02
• 03

oledb

• id
• 01,00
• 02,00
• 03,00

thanks!

[#2]

I want to avoid this ,too.

[#3]

We encountered this problem ourselves & finally came up with a fix. OLE is much more sensitive to data types than ODBC, so you need to match the format exactly.

http://stackoverflow.com/questions/7920637/convert-a-string-date-into-datetime-in-oracle

I realize this is an old post, but hope it helps somebody.

[#4]

Hi all,

i know this is an old post, but has anyone an solution for this problem.

thanks a lot