MS-Oracle ODBC驱动程序功能序列错误 [英] MS-Oracle ODBC Driver Function Sequence Error

问题描述

我正在使用Microsoft-Oracle ODBC驱动程序来访问MS Access中的Oracle数据库，但是在大约一半的链接表上，每当尝试拉起数据表视图时，都会出现[功能序列错误].我四处寻找替代司机，但没有运气.

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

推荐答案

我知道了.问题是Microsoft-Oracle ODBC驱动程序错误地将Oracle的CLOB(字符大对象)字段转换为Access中的纯Text [255 char]字段.然后，每当Access尝试使用超过255个字符来呈现这些CLOBS时，Access都会感到恐惧.

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.

因此，我只是从所有查询和迁移表中排除了那些CLOB字段.这确实意味着我无法迁移描述"或注释"之类的字段，但至少可以迁移主键和关系.就我而言，这已经足够了.

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.

这篇关于MS-Oracle ODBC驱动程序功能序列错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！