Access error (ODBC) sometimes

[G]

I have an access db that links to db2 by using dsn/odbc.

The problem is that on some computers, sometimes, the following error
appears. But I can run the same query on my computer or another users
computer, with no problem.

Error msg =
ODBC--call failed.
[IBM][CLI DRIVER] CLI0113E An invalid datetime format was detected; that is,
an invalid string representation or value was specified SQLSTATE= 22007
(#-99999)

I looked on the internet and all I can find is a reference to put the date
in quotes, or double-check the db2 date format. But since this specific query
will run on other computers, I'm wondering if there is something else
(driver?) that is causing the problem just on certain computers.

Any help is greatly appreciated.

btw, the code is:
SELECT HR04_CURR_COMP3_NC.EMP_ID, HR04_CURR_COMP3_NC.UNION_CD,
PR01_VAC_BAL1_NC.PLN_TYP_CD, PR01_VAC_BAL1_NC.ACCRL_PROC_DT,
PR01_VAC_BAL1_NC.HRS_BAL_QTY
FROM HR04_CURR_COMP3_NC INNER JOIN PR01_VAC_BAL1_NC ON
HR04_CURR_COMP3_NC.EMP_ID = PR01_VAC_BAL1_NC.EMP_ID
WHERE (((PR01_VAC_BAL1_NC.PLN_TYP_CD)="51") AND
((PR01_VAC_BAL1_NC.ACCRL_PROC_DT)=#1/9/2005#) AND
((PR01_VAC_BAL1_NC.HRS_BAL_QTY)<1));

 

[MH]

Things to check:

ODBC driver version
Access Version

If they are both the same on both machines, you should experience the same
problems (unless anyone else can think of something I've missed).

Check online for other ODBC drivers and test them, some will work and some
will be worse if my experience with Oracle ODBC drivers is anything to go
by!

MH