老是报错,提示SQL正在运行
我的代码SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "");
oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database = "Northwind";
oRestore.Files = this.FileUpload1.PostedFile.FileName;
oRestore.FileNumber = 1;
oRestore.ReplaceDatabase = true;
oRestore.SQLRestore(oSQLServer);
Response.Write("<script language=javascript>alert('恢复数据库成功!');location='Index.aspx'</script>");
}
catch
{
Response.Write("<script language=javascript>alert('恢复数据库失败!');location='Index.aspx'</script>");
}
finally
{
oSQLServer.DisConnect();
}
我的代码SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "");
oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database = "Northwind";
oRestore.Files = this.FileUpload1.PostedFile.FileName;
oRestore.FileNumber = 1;
oRestore.ReplaceDatabase = true;
oRestore.SQLRestore(oSQLServer);
Response.Write("<script language=javascript>alert('恢复数据库成功!');location='Index.aspx'</script>");
}
catch
{
Response.Write("<script language=javascript>alert('恢复数据库失败!');location='Index.aspx'</script>");
}
finally
{
oSQLServer.DisConnect();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货