Acess & Oracle Unicode Problem

[Guest]

Hi All

I am accessing an Oracle database via Acess using an ODBC DSN
All is fine until I access a particular field whose data type is described in the linked Oracle table as Memo

My query includes other Memo fields but they are extracted correctly.
When the problem memo field is queried I get an error message
'The width of a Unicode text column must be an even number of bytes'

Any idea if there is a problem with the data or is it my means of accessing the Oracle Database

I am new to Oracle via Access...Any Ideas

Thanks
DaveD

 

[Fahim]

Dave,

I had the same problem. The solution is to use ODBC driver
from Oracle and not the microsoft driver for oracle. All
datatypes get converted fine.

Fahim

-----Original Message-----
Hi All,

I am accessing an Oracle database via Acess using an ODBC DSN.
All is fine until I access a particular field whose data

type is described in the linked Oracle table as Memo.

My query includes other Memo fields but they are extracted correctly.
When the problem memo field is queried I get an error message :
'The width of a Unicode text column must be an even number of bytes'.

Any idea if there is a problem with the data or is it my

means of accessing the Oracle Database?