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")
ms frontpage: ofp = CreateObject("frontpage.Application")
ms access: oaccess = CreateObject("access.Application")
ms graph: ograph = CreateObject("msgraph.Application")
下面是我们应该知道的:
CreateObject("photoshop.Application")
//关于sql server的
CreateObject("sqldmo.sqlserver")
CreateObject("sqldmo.login")
CreateObject("sqldmo.backup")
CreateObject("sqldmo.user")
Server.CreateObject("sqldmo.backupdevice")
Server.CreateObject("sqldmo.database")
Server.CreateObject("sqldmo.restore")
//msmq的
Server.CreateObject("msmq.msmqqueueinfo")
CreateObject("msmq.msmqquery")
//全文索引的
Server.CreateObject("ixsso.query")
Server.CreateObject("ixsso.util")
邮件发送的组件我没有总结,请热心的朋友总结出来:
cdo,jmail,imail等。
下面一些是不太常见的对象:
accpac advantage corporate:
oaccpac=CreateObject("accpac.xapisession")
accpac report master for windows:
oimpapp=CreateObject("impromptu.Application.30")
bartender:
obartender = CreateObject("bartender.Application")
crystalreports:
ocrApplication = CreateObject ("crystalruntime.Application")
this doesnt invoke an ide actually.
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")(domino 5.0.3)
ms common dialog:
ocommmondialog = CreateObject("mscomdlg.commondialog")&& !!! you cant directly create this object without a development licence, so for dynamically doing it on another machine, see below. -- petercrabtree
ms internet explorer:
oie = CreateObject("internetexplorer.Application")
ieautomationexample
ms mappoint:
omappoint = CreateObject("mappoint.Application")
msn messenger:
omessenger = CreateObject("msnmessenger.messengerapp")
ms netmeeting:
onetmeeting=CreateObject("netmeeting.app.1")
ms outlook:
ooutlook = CreateObject("outlook.Application")
ms outlook express: none - it is not a com server!
ms powerpoint:
opp = CreateObject("powerpoint.Application")
ms project:
oproj = CreateObject("msproject.Application")
ms sourcesafe:
ovss = CreateObject("sourcesafe.0")
ms word:
oword = CreateObject("word.Application")
ms visio:
ovisio = CreateObject("visio.Application")
ms visualbasic: 不知道,网站也没有登记出来。
ms visualcplusplus: (vc++)
ocpp = CreateObject("msdev.Application")
ms visualfoxpro:
ovfp = CreateObject("visualfoxpro.Application")
ms windowsscriptinghost:
owsh = CreateObject("wscript.shell")
novell groupwise:
ogroupwise = CreateObject("novellgroupwaresession")
pcanywhere (host):
opcahost = CreateObject("winawsvr.behostdatamanager")
pcanywhere (remote):
opcarem = CreateObject("winawsvr.remotedatamanager")
quickbooks:
qbsessionmanager = CreateObject("qbfc2.qbsessionmanager")
rationalrose:
orose = CreateObject("rose.Application")
tapifax:
otapifax = CreateObject(faxserver.faxserver)
windowsshell:
owsh = CreateObject("shell.Application")
windows media player:
owmp = CreateObject("wmplayer.ocx")
oplaylist = owmp.playlistcollection.getall()
owmp.currentplaylist = oplaylist.item(0)&& zero based array *!* music starts!
windows messenger:
omessenger = CreateObject("messenger.messengerapp")
winfax:
owinfax = CreateObject("winfax.sdksend")
winprint :
owinprint = CreateObject("winprint.winprintx")
sql-dmo object:
losql = CreateObject("sqldmo.Application")
others:
scripting shell:
oshell = CreateObject("wscript.shell")
scripting network object:
onet = CreateObject("wscript.network")
scripting regular expression_r_r parser:
oreg = CreateObject("vbscript.regexp")
sql dmo sql server:
CreateObject("sqldmo.sqlserver")
参考:http://www.asp101.com/articles/carvin/sqldmobackup/default.asp