MS Access 2013 64-bit
Oracle 11g
64-bit driver: Oracle in OraClient 11g_home1

I'm getting this annoying message, and I don't know why.

I have two tables on the data base which I've linked to in MS Access, when I open the tables they open just fine.
I created a query for each of the tables to just select * and they both run just fine.
when I add a date field to both queries and put the same criteria in for both queries one runs and the other gives the error message "ODBC--call failed."
when I run the same filtered queries on another computer using 32-bit MS Access 2013 using the 32-bit "Microsoft ODBC for Oracle" driver both filtered queries run just fine.

on the 64-bit driver there is an option on the "Workarounds" tab for "Bind TIMESTAMP as DATE", but checking and unchecking this box seems to make no difference.

in access I've also tried setting the timeout on the query against table 1 to 60000, but that didn't help either.

Please Login or Register  to view this content.
TABLE_NAME COLUMN_NAME DATA_TYPE DATA_TYPE_MOD DATA_TYPE_OWNER DATA_LENGTH DATA_PRECISION DATA_SCALE NULLABLE COLUMN_ID DEFAULT_LENGTH DATA_DEFAULT
TABLE1 PO_DATE DATE 7 N 11
TABLE2 EXPIRE_DT DATE 7 N 8


is there some other 64-bit setting I'm missing here? why under 64 bit would it work for one table and not the next, why does it work for both tables on 32-bit but not 64?