110,534
社区成员
发帖
与我相关
我的任务
分享
string sqlca=''Persist Security Info=True;Initial Catalog=yfasrs;User ID=sd;Password=admin;Data Source='166.110.1.2';
SqlConnection sqlcommon = new SqlConnection(sqlca);
sqlcommon.Open();
SqlTransaction otcommon = sqlcommon.BeginTransaction();
try
{
string sqlcommon4 = "update OPENDATASOURCE( 'SQLOLEDB', 'Data Source=166.110.1.1;User ID=sd;Password=admin' ).yferp.dbo.INVLA set LA025='R' where LA016=' e111'";
}
SqlCommand ocom_stkmast3 = new SqlCommand(sqlcommon3, sqlcommon);
ocom_stkmast3.Transaction = otcommon;
try
{
ocom_stkmast3.ExecuteNonQuery();
}
catch (SqlException t)
{
otcommon.Rollback();
ocom_stkmast3.Dispose();
sqlcommon.Dispose();
sqlcommon.Close();
}
exec sp_addlinkedserver '链接服务器名', '', 'SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin '链接服务器名'','false',null,'用户名','密码'
多个数据源,可以考虑Transactionscope,详情见:https://msdn.microsoft.com/zh-cn/library/system.transactions.transactionscope(v=vs.80).aspx