does anyone know why oracle would not accept timestamps?
when i try to insert Now() into a date/time field, oracle returns with the
error "illegal character". FYI, Now() outputs a timestamp like:
{ts 'yyyy/mm/dd hh24/mi/ss'}
stranger yet... all my queries work when i run the application locally on a
workstation with an ODBC connection out to the database. however, the
application refuses to work when i run the application locally on the
database.
the workstations are Win2000, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver
the server is WinNT SP6a, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver
ideas???
-mike
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
