Truncation of ms access memo field odbc connected (10g) to oracle db with clob field

[jefseyen]

When we view a field with type 'memo' in a table (so even not in a query ) which is odbc connected to an oracle table where the corresponding field is a clob field , it is truncated.

I want to know to avoid that.

It is strange as earlier this was not the case for another field of another table, similarly connected.
After i got this issue for the other field , it is also the case for the other field now , so my earlier queries give a truncated value for that field.

jef

[Stewart Ross]

Hi jefseven. From the limited information I can gain by Google searching this appears to be some form of ODBC driver issue. It is apparently not an Access issue as such, from what this unresolved Oracle support thread mentions.

There are a few other similar queries to your own out there (including one from you for the same question in another forum!) but I have not seen any resolution.

MSDN VB Net data suggests that the CLOB type is mapped in VB Net to a string type, and this in turn is consistent with the use of a Memo data type in the ODBC mapping. From this, if the ODBC mapping is to a character field it would indeed appear to be an ODBC driver problem more than anything else.

Sorry I can't be of more assistance here.

-Stewart