Large objects from Oracle to Access

  • Thread starter Thread starter Sylvia
  • Start date Start date
S

Sylvia

I am trying to link to a table in oracle database from
access 2000. This linked table happens to have a CLOB
datatype as one of its field. Access converts this to a
Text field and when selected from this table, I get an
error message.

ODBC call failed. [Microsoft] [ODBC Driver Manager]
Function Sequence Error (#0)

Can someone please help me get around this problem.
Thanks in advance.
..
 
Just create a new ODBC connection using a new driver for Oracle. How many records are you trying to import? Access has some problems after 200000 records. I hope that this helps.
 
Back
Top