Acess & Oracle Unicode Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
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
Click to expand...
means of accessing the Oracle Database?
 
Back
Top