Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 14:25:54 GMT


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


Subj:   Re: ASP & Teradata Macros
 
From:   Kyle Prescott

This is known issue between Teradata ODBC v3 driver (anything before 3.2.x) and ADO. The ODBC driver 2.08.02.x driver works correctly also. The Teradata ODBC driver 3.02.00.00 (TTU 7.0) and later works correctly.

The truncation of decimals only happens between Teradata ODBC/ADO (when the OLE provider is MSDASQL). Since Queryman does not utilize ADO, it does not appear. However when using ASP or any other application that utilizes ADO for connectivity, the truncation will occur on Teradata ODBC v3 drivers prior to TDODBC v3.02.00.00.

Another option is to use the Teradata native OLE DB provider (TDOLEDB.DLL)

The only work around without changing drivers is to cast the decimal as character.



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