Archives of the TeradataForum

Message Posted: Sat, 02 Aug 2003 @ 15:08:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This is a known issue within the Teradata ODBC driver v3.0 and v3.1 with MS-ADO (MS OLE DB Provider for ODBC Drivers - MSDASQL). The interface causes decimal truncations. This is only found when using the ODBC via MS-ADO. Queryman does not use ADO, so it will not appear.

TTU 7.0 ODBC driver v3.02.00.x corrects the issue. Teradata ODBC driver v2.08.02.05 also works - although I believe the v2.2 OLEDB_AXSMOD has a requirement of the v3 Teradata ODBC driver or above.

Also utitilizing the native Teradata OLE Provider (TDOLEDB) does not have this issue.

Kyle Prescott
Teradata Certified Professional
UnumProvident - Data Strategies, 3-South

	<Prev	Next>		<<First	<Prev	Next>	Last>>