[AccessD] Access 97 and A2k with Oracle 9.0.1

Drawbridge.Jack at ic.gc.ca Drawbridge.Jack at ic.gc.ca
Thu Aug 5 15:11:32 CDT 2004


I have 2 databases (1 access 97 , 1 access 2000)
 both using ODBC to Oracle  Ora9.0.1

With Access 97'
 I can insert records containing memo fields (50 - 800 chars) into Oracle
varchar2(4000) column without error.  

With A2K, similar records with memo fields  fail with 
" ORA-1416 - can bind a long value only for insert into a LONG column."

Does anyone have a solution/fix/wrkaround for this?

TIA
Jack



More information about the AccessD mailing list