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.