Import NCLOB field from Oracle to MS Access 2003

A

Alex

When I try to import external data from Oracle to MS Access 2003 using Oracle
ODBC Driver, I got error saying "ORA-24806: LOB form mismatch (#24806)".
In the Oracle table, we do have a NCLOB column. It's a LOB and it is
unicode. I wonder whether MS Access has any way to read this kind of info.

Thanks
 
C

Crazyhorse

When I try to use Active X control and a ADO control I get Mismatch errors
sometime. Double check you references in you code. If you do not know where
the referneces are they are under tools> References when in the Module
section. The database can not run both and the sametime. One or the other.
 
A

Alex

Thank you for the response.
But, I am actually doing the import from MS Access application/File/Get
External Data/Import. I don't have to do the reference. Or, I can do the
reference in MS Access?
 

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

Top