Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019