OLE DB提供程序“OraOLEDB.Oracle”对于链接服务器，为列提供了不一致的元数据。据报道，对象的列（编译时序号1）具有“DBCOLUMNFLAGS_ISFIXEDLENGTH”。编译时为16，运行时为0 [英] The OLE DB provider "OraOLEDB.Oracle" for linked server supplied inconsistent metadata for a column. The column (compile-time ordinal 1) of object was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time
问题描述
Hi Brains
我试图从Link服务器访问Oracle数据库并收到以下错误。当我在oracle端手动创建新表时，我将访问新表。问题是按应用程序模式（CVADM）拥有的现有表
数据库链接用户是"repusr"
Oracle数据库模式是"CVADM" ;
Linkedname" CVRPT"
+++++++++++++++++++++++++++++++++++ +
OLE DB提供程序"OraOLEDB.Oracle"用于链接服务器 为列提供了不一致的元数据。专栏 据报道，对象的（编译时序数1）具有"DBCOLUMNFLAGS_ISFIXEDLENGTH"。 16在编译时
和0在运行时
+++++++++++++++++++++++++++++++++++++ b
1。当创建新表（T1）时，我可以从Lik服务器访问如下
select * FROM [CVRPT] .. [CVADM]。[T1] GO
2。有问题的表格（CVADM.ACCOUNT）我可以按如下方式访问 使用openquery
SELECT * FROMOPENQUERY（CVRPT，' SELECT * FROM CVADM.ACCOUNT，其中rownum< 15'）;
发生了
问题，而 按以下方式访问
选择*来自[CVRPT] .. [CVADM]。[帐户]
3我尝试了所有 其他表和问题对于其他表是相同的。
4。用户"repusr"也是oracle用户并且已经"选择"了模式访问"CVADM"表格
5.提供商" ORaOLEDB.Oracle启用以下选项。
启用以下选项
允许inprocess
嵌套查询
支持"赞"运算符
6.我创建了其他链接"ERPSAP"到oracle其他DB"SAPRPT"我可以访问数据 没有问题使用相同的提供者（ORAOLEDB.Oracle）
任何人都可以提供帮助将非常感激
Hi ashwan，
>> OLE DB提供程序"OraOLEDB.Oracle"用于链接服务器 为列提供了不一致的元数据。专栏 据报道，对象的（编译时序数1）具有
a"DBCOLUMNFLAGS_ISFIXEDLENGTH"。编译时为16，运行时为0
根据我的研究，您的问题与Oracle有关。您能参考以下链接中的步骤：
https://windows7bugs.wordpress.com/2018/12/31/oracle-linked-server-ms-sql/
希望这可以帮助你。
祝你好运，
Dedmon Dai
Hi Brains
I am trying to access the Oracle database from Link server and getting following error. When I manully create new table in oracle side , then I am to access new tables. The Issue is existing tables which own by application schema(CVADM)
DB link user is "repusr"
Oracle database schema is "CVADM"
Linkedname "CVRPT"
+++++++++++++++++++++
The OLE DB provider "OraOLEDB.Oracle" for linked server supplied inconsistent metadata for a column. The column (compile-time ordinal 1) of object was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time
++++++++++++++++++
1. When created new table(T1) I can access from Lik server as follows
select * FROM[CVRPT]..[CVADM].[T1] GO
2. Problematic tables(CVADM.ACCOUNT) I can access as follows using openquery
SELECT *FROMOPENQUERY(CVRPT,' SELECT * FROM CVADM.ACCOUNT where rownum<15');
issue occurred while accessing on following way
select * FROM[CVRPT]..[CVADM].[ACCOUNT]
3. I tried all other tables and issue is same for other tables.
4. User "repusr" also oracle user and has "select" access on schema "CVADM" tables
5. Provider "ORaOLEDB.Oracle enabled following options.
Enable the following options
Allow inprocess
Nested Queries
Support "Like" operator
6. I created other link "ERPSAP" to oracle other DB "SAPRPT" and I can access the data and no issue using same provider(ORAOLEDB.Oracle)
Any one can help would be much appreciated
Hi ashwan,
>>The OLE DB provider "OraOLEDB.Oracle" for linked server supplied inconsistent metadata for a column. The column (compile-time ordinal 1) of object was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time
Based on my research, your issue is more related to Oracle. Would you please refer to the steps in the link below: https://windows7bugs.wordpress.com/2018/12/31/oracle-linked-server-ms-sql/
Hope this could help you .
Best regards,
Dedmon Dai
这篇关于OLE DB提供程序“OraOLEDB.Oracle”对于链接服务器，为列提供了不一致的元数据。据报道，对象的列（编译时序号1）具有“DBCOLUMNFLAGS_ISFIXEDLENGTH”。编译时为16，运行时为0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
