[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

491.0. "DATE ANSI and delete problem" by HYLNDR::LEE () Thu Mar 10 1994 16:18

T.RTitleUserPersonal
Name
DateLines
491.1BROKE::MESENZEFFThu Mar 10 1994 17:514
491.2date for ANSI date support?JRFVAX::HODGESThu Mar 10 1994 19:255
491.3BROKE::MESENZEFFThu Mar 10 1994 20:1818
491.4ANSI DATETIME Supported in Oracle ODBC for RDB?ORAREP::AWECIM::HOWARDFri Feb 14 1997 13:3220
This original note was written in March '94.

I'm having trouble in MS-Access looking at any Rdb tables containing ANSI DATETIME. The 
tables use datatypes TIMESTAMP(2) and DATE ANSI.  MS-Access issues a message "ODBC-call 
failed" and shows all values in these tables as "#Name?".

When this original note was written, support was not provided in the odbc driver.
Did Digital or Oracle provide this support or is it still unsupported?

I am using:

   PC:
        Windows NT 3.51 (with Service Pack 4)
        Access for Windows 95 V7.0
        ODBC RDB V2.10.11 32-bit with TCP/IP

   OpenVMS:
        DEC SQL V6.1-0
        DEC Rdb V6.1-0
        Rdb/Dispatch V6.1-0 (OpenVMS AXP) 
491.5yup...M5::JBALOGHFri Feb 14 1997 15:324
    Yes, support for Date Ansi and Timestamp were added in 6.1-0 SQLSRV
    with 2.0.x ODBC. 
    
    John
491.6ORAREP::AWECIM::HOWARDFri Feb 14 1997 16:525
Do you have any suggestions as to why I'm getting the errors as described in .4?

Thanks,
John