Access 2000 and Oracle

A

Arno Weiershaeuser

I have linked and Oracle table via ODBC with Access 2000.
The oracle table includes one LONG field, the
corresponding field of the Access table is a MEMO field.
When I try to change the content of this field in Access,
I always get the error message:
"The width of a unicode text column must be an even number
of bytes".
I already found the hint to enable "Force Retrieval of
Long Columns" in the ODBC setup, but that did not help.

Regards,
Arno Weiershäuser
 
K

Ki Yi [MS]

Hello,

I have see few issues related to your error. Resolution was to use
Microsoft ODBC driver for Oracle. If this not an option, then
I would check with Oracle to see if they have seen this issue before.

Hope this helps!

Ki
 
A

Arno Weiershaeuser

Hello,

updating my oracle odbc driver solved this problem.

Arno Weiershaeuser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get real oracle error with Access error 3155 0
Acess & Oracle Unicode Problem 1
Linking Access and Oracle Database 2
Access 2003 ODBC to Oracle CLOB field show in Access text type 0
Access, Oracle and Special Characters 1
Access 2007 ODBC for Oracle linked table issue 0
Import NCLOB field from Oracle to MS Access 2003 2
Need help with Access 97 and Oracle 9i 6

Top