Oracle Database Link Problems

cle 8 数据链路在程式中不能支持:
    ODBC
       数据不可提交,无错误,偶尔会有错误。
    Microsoft OLE DB 
       数据不可提交,无错误
    Oralce OLE DB (在BPCS上可以,但在Cimprod不可以)
       错误为:
        ORA-02041: client database did not begin a transaction
 
   Oracle的说明:
cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol. 
  
Action: If the cause is the former, check that any commit is not followed by an update.
 
暂无解决办法,还是通过Procedure 通过DB link把资料转入GSN DB.
 
SQL Server 的Link Server:
    也发生如下状况,一直好好的procedure突然出现,但Link server好好的。
   [Microsoft][ODBC SQL Server Driver][SQL Server]對遠端伺服器的存取被拒,因登入對應不存在。
    临时解决办法把建立connect的用户的权限提高为Server administrator.
[@more@]
请使用浏览器的分享功能分享到微信等