I would guess that the default Oracle date format on the two machines is set
differently. Unfortunately a cursory search did not turn up info on
how/where this is set.
-----Original Message-----
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 6:56 PM
To: Cf-Talk
Subject: oracle & timestamps
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.
------------------------------------------------------------------------------
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.
