Large objects from Oracle to Access

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.
..
 
G

Guest

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.
 

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

Similar Threads

Can't get real oracle error with Access error 3155 0
Access 2003 ODBC to Oracle CLOB field show in Access text type 0
Access 2007 ODBC for Oracle linked table issue 0
Linking Access and Oracle Database 2
Need help with Access 97 and Oracle 9i 6
Oracle to Access 1
linking oracle to access 1
Import NCLOB field from Oracle to MS Access 2003 2

Top