Archives of the TeradataForum
Message Posted: Tue, 20 May 2003 @ 14:25:54 GMT
| 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.
| 
