Access 2000/Oracle ODBC Error

[richardii]

I have set up an ODBC link to an Oracle database (8i).

I receive the message:

The width of a UNICODE text column must be an even number of bytes

when querying data from GENEVAPRS. I've tried setting the Force Retrieval of Long columns flag in ODBC (for the Oracle driver). The registry entry looks okay (as far as I can tell). Still does it though....

Any tip appreciated.

This is a known problem (it's known by University of Arkansas) -

http://www.uaex.edu/bknox/ms_access_2000_oracle_long_datatype.htm

 

[richardii]

I used the Microsoft ODBC for Oracle Driver, and had no problem.