积极答复者
Oracle server instance cannot be enabled as a Publisher

问题
-
sqlserver 2005 sp4 ,use replication function to publisher oracle database ,meet some error ,sqlserver run on window 2003 64bit ,i have installed oracle client 64bit ,and sqlserve can use link to access oracle ,why ?
Oracle server instance 'webdb2' cannot be enabled as a Publisher because of the following error: (Distributor Properties)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.5000.00&EvtSrc=Microsoft.SqlServer.Management.UI.ConfigureWizardErrorSR&EvtID=OraclePublisherValidateFailed&LinkId=20476===================================
OLE DB provider 'OraOLEDB.ORACLE' for linked server '(null)' returned data that does not match expected data length for column '[OraOLEDB.ORACLE].'ALL''. The (maximum) expected data length is 64, while the returned data length is 6. (.Net SqlClient Data Provider)
houbin
答案
-
您好,
请参考:如何在 SQL 服务器中设置到 Oracle 的链接服务器并进行故障排除.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.- 已标记为答案 Molly Chen_Moderator 2011年10月12日 5:02
全部回复
-
您好,
请参考:如何在 SQL 服务器中设置到 Oracle 的链接服务器并进行故障排除.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.- 已标记为答案 Molly Chen_Moderator 2011年10月12日 5:02