Archives of the TeradataForum
Message Posted: Sat, 02 Aug 2003 @ 15:08:10 GMT
Subj: | | Re: Fastload truncating Decimals |
|
From: | | Prescott, Kyle R |
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
|