资源描述:
《sqldmo(分布式管理对象)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、sqldmo(分布式管理对象)SQLDMOregistrationmethod:1,includingfilesandroutingFilenamelocationSqldmo.dll,c:Program,FilesMicrosoft,SQL,Server80ToolsBinnSqlresld.dllexecutabledirectorySqlsvc.dllexecutabledirectoryW95scm.dll,Installation,drive:Program,FilesMicrosoft,SQL,Server80ToolsBinnSqlsvc.rl
2、lexecutabledirectoryresources2052Sqldmo.rll,c:Program,FilesMicrosoft,SQL,Server80ToolsBinnResources1033Sqlunirl.dllc:windowssystem322,executetheDOScommandRegSvr32sqldmo.dll------------------------------------------------------------------------------It'sbeenalongdaysinceIsignedupf
3、orsqldmosothateveryonecansavetimeafterregisteringforsqldmo!Theresultsareasfollows:Tobuildaproject,thecodeisasfollows:(directcopycanbe)UsingSystem;UsingSystem.Collections.Generic;UsingSystem.ComponentModel;UsingSystem.Data;UsingSystem.Drawing;UsingSystem.Text;UsingSystem.Windows.Forms;UsingSy
4、stem.IO;UsingSystem.Diagnostics;Namespacedeploymentdemo{Public,partial,class,Form1:Form{Public,Form1(){InitializeComponent();}PublicvoidDeploySQLDMO(stringdllPath){StringsystemPath=Environment.GetFolderPath(Environment.SpecialFolder.System);StringsqlwoaFile=String.Format(@{0}sqlwoa.dll',sys
5、temPath);StringsqlwidFile=String.Format(@{0}sqlwid.dll',systemPath);If(...File.Exists(sqlwoaFile)){File.Copy(String.Format(@{0}sqlwoa.dll',dllPath),sqlwoaFile);}If(...File.Exists(sqlwidFile)){File.Copy(String.Format(@{0}sqlwid.dll',dllPath),sqlwidFile);}ProcessP=new,Process();P.StartInfo.
6、FileName="regsvr32.exe"";P.StartInfo.Arguments=String.Format("/s{0}\sqldmo.dll",dllPath);P.StartInfo.WorkingDirectory=systemPath;P.StartInfo.WindowStyle=ProcessWindowStyle.Hidden;P.Start();P.WaitForExit();P.Close();}Private,void,Form1_Load(object,sender,EventArgs,e){DeploySQLDMO("D:\SQLDMO
7、");}}}Note:inthedllPathfoldermustincludeSQLDMO.DLL,sqlresld.DLL,sqlsvc.DLL,sqlwid.dll,sqlwoa.dll,w95scm.DLLandanamefortheResourcesfolder,Resourceshasanameforthe2052folder,SQLDMO.RLL2052,sqlsvc.RLLevenfilesIfnecessary,practiceme(QQ:393209543)-------