HELP ODBC, ORACLE and insert of DATES

From: Patricia Buickerood <buickero_at_kodak.com>
Date: 1997/05/06
Message-ID: <336F2F85.6FC9_at_kodak.com>#1/1


Am trying to insert dates into an Oracle date column using C program (MS C V4.1), MS ODBC Driver 2.0, Oracle ODBC 1.15.3.1.0A on an NT 4.0 workstation. Oracle release 7.1.6.2.0.... Different fCType and fSqlType combinations fail either on SQLBind or on SQLExecute. Oracle documentation indicates support for SQL_TIMESTAMP to Oracle DATE but program fails on SQLBind with "Driver not capable". Oracle also indicates that SQL_C_CHAR to SQL_CHAR should work. This fails on execute with sqlstate 22003 - "Numeric value out of range" error. Anyone had any success inserting dates into Oracle using these tools? Clues, suggestions ... Help! Received on Tue May 06 1997 - 00:00:00 CEST

Original text of this message