马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
因为现在数据库都使用标准的SQL语言对数据库进行管理,所以如果是标准SQL语言,两者基本上都可以通用的。SQLServer还有更多的扩展,可以用存储过程,数据库大小无极限限制。工具ADO工具(太经常使用了):
Connection
Command
RecordSet
Record
Stream
ASP撑持的工具太多了,你能够本人写COM组件,上面是我们常常利用的:
Server.CreateObject("Scripting.FileSystemObject")
Server.CreateObject("Scripting.Dictionary")HashTable
Server.CreateXObject("Word.Application")//Server
ActiveXObject("Word.Application")//Client
Server.CreateObject("Excel.Application")//Server
ActiveXObject("Excel.Application")//Client
CreateObject("PowerPoint.Application")
Server.CreateObject("Microsoft.XMLHTTP")
Server.CreateObject("Microsoft.XMLDOM")
Server.CreateObject("MSXML2.XMLHTTP.4.0")
Server.CreateObject("WScript.Shell")
Server.CreateObject("wscript.network")//收集地点的
Server.CreateObject("MSWC.AdRotator")
CreateObject("Excel.Sheet")
MSFrontPage:oFP=CreateObject("FrontPage.Application")
MSAccess:oAccess=CreateObject("Access.Application")
MSGraph:oGraph=CreateObject("MSGraph.Application")
上面是我们应当晓得的:
CreateObject("Photoshop.Application")
//关于SQLServer的
CreateObject("SQLDMO.SQLServer")
CreateObject("SQLDMO.Login")
CreateObject("SQLDMO.Backup")
CreateObject("SQLDMO.User")
Server.CreateObject("SQLDMO.BackupDevice")
Server.CreateObject("SQLDMO.Database")
Server.CreateObject("SQLDMO.Restore")
详细的例子请看上面的毗连
http://www.asp101.com/articles/carvin/sqldmobackup/default.asp
//MSMQ的
Server.CreateObject("MSMQ.MSMQQueueInfo")
CreateObject("MSMQ.MSMQQuery")
//全文索引的
Server.CreateObject("ixsso.Query")
Server.CreateObject("ixsso.Util")
邮件发送的组件我没有总结,请热情的伴侣总结出来:
CDO,Jmail,Imail等。
上面一些是不太罕见的工具:
AccPacAdvantageCorporate:
oAccPac=CreateObject("ACCPAC.xapiSession")
AccPacReportMasterforWindows:
oImpApp=CreateObject("Impromptu.Application.30")
BarTender:
oBarTender=CreateObject("BarTender.Application")
CrystalReports:
oCRApplication=createobject("CrystalRuntime.Application")
ThisdoesntinvokeanIDEactually.
EUDORA:
oEud=CreateObject("Eudora.EuApplication.1")
FaxMaker:
oFax=CREATEOBJECT("fmfaxapi.application")
GroupWise:
oGroupWise=CreateObject("NovellGroupWareSession")
LotusNotes:
oNotes=CreateObject("Notes.NotesSession")
oNotes=CreateObject("Notes.NotesUIWorkspace")
oNotes=CreateObject("Lotus.Notessession")(Domino5.0.3)
MSCommonDialog:
oCommmonDialog=CreateObject("MSComDlg.CommonDialog")&&!!!Youcantdirectlycreatethisobjectwithoutadevelopmentlicence,sofordynamicallydoingitonanothermachine,seebelow.--PeterCrabtree
MSInternetExplorer:
oIE=CreateObject("InternetExplorer.Application")
IEAutomationExample
MSMapPoint:
oMapPoint=CreateObject("MapPoint.Application")
MSNMessenger:
oMessenger=CREATEOBJECT("MSNMessenger.MessengerApp")
MSNetMeeting:
oNetMeeting=CREATEOBJECT("netmeeting.app.1")
MSOutlook:
oOutlook=CreateObject("Outlook.Application")
MSOutlookExpress:None-ItisnotaCOMserver!
MSPowerPoint:
oPP=CreateObject(</p>[1][2]下一页
缺点:安全性不是太差了,还行,只要你充分利用系统自带的工具;唯一缺点就是执行效率慢,如何进行网站优化以后,效果会比较好。 |