ODBC-datetime fields??

I am using Cardiff's Teleform to enter data to Oracle8 via ODBC 3.01. Dates are exported by Teleform as text. We have in the past used triggers to convert an incoming text field to date type, but this requires 2 fields in the table for any given date; one for the text value, and one for the date value.

I have tried using Teleform's BasicScript to convert a mm/dd/yy format to dd-mon-yy format, still exporting as text, but in the default date template for my database. The script works fine, but I get an ODBC error 'Datetime field overflow. Error in parameter 2.'

Has anyone experience with this type of problem? Or, is there a NG dedicated to ODBC?

Thanks,
Misha Received on Fri Mar 19 1999 - 16:44:05 CST