CODEWITHSUNDEEP
oracle-databaseodbcms-access-2007
Jack
Jack

Reputation: 188

MS-Oracle ODBC Driver Function Sequence Error

I'm using the Microsoft-Oracle ODBC Driver to access an Oracle database in MS Access, but on about half of my linked tables, I get a [Function Sequence Error] whenever I try to pull up the Datasheet view. I've looked around for alternative drivers, but no luck.

Does anyone know how to stop getting these function sequence errors? And if I need a new driver, could you provide a link if possible to a download site? Thanks

Upvotes: 3

Views: 5053

Answers (1)

Jack
Jack

Reputation: 188

I figured it out. The problem was that the Microsoft-Oracle ODBC driver mistakenly converted Oracle's CLOB (Character Large Object) fields into mere Text[255 char] fields in Access. And then Access freaked out whenever it tried to render these CLOBS with more than 255 characters.

So I just excluded those CLOB fields from all my queries and migration tables. It does mean that I can't migrate over fields like "Description" or "Notes," but at least I can migrate over the primary keys and relationships. That's good enough for me, for now.

Upvotes: 3

Related Questions