Hello to all,
maybe it's a scrilege but I have to ask this.

I've linked a firebird 1.02 table to MS Access2000 using the IB Phoenix
ODBC-driver.
'Beginn' is of type TIMESTAMP.

If I start the query

SELECT TBLPRODUKTION.*
FROM TBLPRODUKTION
WHERE ((([TBLPRODUKTION].[BEGINN])>=#1/1/2003 0:0:1#));

in Access accessing the firebird table I get this error message

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 83
'2003-01-01 00:00:01' (#335544569)

Does anyone know what's going wrong.
As far as I know is '2003-01-01 00:00:01' a valid date format.


MEP Kutsch GmbH & Co. KG
Flaßkuhle 1
58452 Witten
Tel.: 02302 28262-30
Fax.: 02302 28262-99

mailto:ralf.erdmann@...

http://www.mep.de