想做个备份SQL的
public void SQLBACK(string ServerIP, string LoginName, string LoginPass, string DBName, string BackPath)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(ServerIP, LoginName, LoginPass);
oBackup.Database = DBName;
oBackup.Files = BackPath;
oBackup.BackupSetName = "数据库";
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch (Exception e)
{
Response.Write(e.Message);
}
finally
{
oSQLServer.DisConnect();
}
}
SQLDMO.Backup里的Backup可以调出来,但是却报错,说缺少SQLDMO命名空间?
我引用了SQLDMO.DLL,它保存在了bin文件夹下面是不是这样的
请大虾们指教
public void SQLBACK(string ServerIP, string LoginName, string LoginPass, string DBName, string BackPath)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(ServerIP, LoginName, LoginPass);
oBackup.Database = DBName;
oBackup.Files = BackPath;
oBackup.BackupSetName = "数据库";
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch (Exception e)
{
Response.Write(e.Message);
}
finally
{
oSQLServer.DisConnect();
}
}
SQLDMO.Backup里的Backup可以调出来,但是却报错,说缺少SQLDMO命名空间?
我引用了SQLDMO.DLL,它保存在了bin文件夹下面是不是这样的
请大虾们指教
我现在想在ASPX页面来引用dll,是上面的错误,是不是我的方法错了
要不就是没有using
namespace DbService
{
///
/// DbOper类,主要应用SQLDMO实现对Microsoft SQL Server数据库的备份和恢复
///
public sealed class DbOper
{
///
/// DbOper类的构造函数
///
private DbOper()
{
}
///
/// 数据库备份
///
public static void DbBackup()
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "1234");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "Northwind";
oBackup.Files = @"d:Northwind.bak";
oBackup.BackupSetName = "Northwind";
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
///
/// 数据库恢复
///
public static void DbRestore()
{
SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "1234");
oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database = "Northwind";
oRestore.Files = @"d:Northwind.bak";
oRestore.FileNumber = 1;
oRestore.ReplaceDatabase = true;
oRestore.SQLRestore(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
}
}
我添加引用---bin下面就有Interop.SQLDMO.dll
我在.cs页面开始调用SQLDMO,打SQLDMO没有提示,但敲个.的时候就有Backup 等等出来了
我浏览的时候就出现 找不到类型或命名空间名称“SQLDMO”(是否缺少 using 指令或程序集引用?) 的错误
我找了用这种方法 [DllImport(@"XX")] 就是 必须在标记为“static”和“extern”的方法上指定 DllImport 属性这种错误 望解决谢谢
using System.Data.Sql;了吗
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Runtime.InteropServices;
using System.Reflection;
using System.Data.SqlClient;
using System.Data.Sql;SQLDMO这个也可以显示出来了,却还是报缺少 SQLDMO 命名空间 真的疯了
反射也用了(只是加载dll进来 还不怎么会用)
很奇怪的是:缺少命名空间SQLDMO 但是又有代码提示
急用,拜求!!!!