Archives of the TeradataForum
Message Posted: Fri, 07 May 2004 @ 18:24:17 GMT
In order to work out the MS Access date problem, NCR has come up with a patch for MS Access. It has some different property settings that allow the DATE() function to work w/ Teradata. If you recall, any driver after 2.06 had a date/timestamp conflict w/ MS Access. The 3.03.00.02 patch resolves this, but we have to use a separate DSN to take advantage of it. Any MS Access databases you have should be re-linked to this new ODBC.
All things being the same except for the driver options:
Check "Use X Views" here. Then hit the advanced button.
Advanced Driver Options:
Check "Enable MS-Access Timestamp Interoperability Mode
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|