Acess & Oracle Unicode Problem
From: Fahim (anonymous_at_discussions.microsoft.com)
Date: 04/23/04
- Next message: John Nurick: "Re: Import from Excel"
- Previous message: ChrisH: "RE: Importing from Paradox"
- In reply to: Dave: "Acess & Oracle Unicode Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Apr 2004 12:50:25 -0700
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?
>
>
>I am new to Oracle via Access...Any Ideas?
>
>Thanks,
>DaveD
>.
>
- Next message: John Nurick: "Re: Import from Excel"
- Previous message: ChrisH: "RE: Importing from Paradox"
- In reply to: Dave: "Acess & Oracle Unicode Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
