ODBC, STORED PROCEDURES AND DATES

[Quoted] [Quoted] I am having trouble getting an ODBC call to stored procedures with Date arguments to work. I have created a simple stored procedure that does nothing but try to except a date argument. I have tried many different ways of inputting the date.
'09/09/96'
'09-AUG-97'

{ts 09-AUG-97}

etc...

I want to use Oracles standard data type so that I can get datatype checking on the function/procedure call.

With the MSODBC driver I get the error: {2.00.006325} 22008[Microsoft][ODBC driver for Oracle]Datetime field overflow.

With Oracles driver I get the error: {2.00.0301} 22008[Oracle][ODBC driver for Oracle]Invalid date, time or timestamp value.

Does anyone have any input/suggestion?

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.