<p>创建一个DSN--less数据库连接<br/>set conn=server.CreateObject(&quot;ADODB.Connection&quot;)<br/>str=&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data source=server.MapPath(&quot;data.mdb&quot;)<br/>conn.open str<br/><br/>ado command对象<br/>set objcommand=server.CreateObject(&quot;ADODB.Command&quot;)<br/>属性<br/>activeconection,command Text<br/>CommandTimeOut,commandType<br/>Name,prepared,state<br/><br/>方法：<br/>cancel,createparameter,execute,parameters,properties<br/><br/>ado connection对象<br/>set objectConnection=server.CreateObject(&quot;ADODB.Connection&quot;)<br/>属性：<br/>Attributes,commandTimeout,connectionstring,connection timeout,cursorLocation,<br/>default database,isolationlevel,mode,privider,state,version<br/>方法:beginTrains,cancel,close,commitTrans,execute,open,openschema,rollbacktrans<br/><br/>事件<br/>begin transcomplete<br/>commitTranscomplete<br/>connectComplete<br/>Disconnect<br/>ExecuteComplete<br/>infoMessage<br/>RollbackTransComplete<br/>willConnect,willExecute<br/><br/>集合errors,properties<br/><br/>ado error对象<br/>属性description,help Context,hellpfile,nativeError,Number,source,sqlstate,<br/><br/>ado filed对象<br/>set objFiled=server.CreateObject(&quot;adodb.filed&quot;);<br/><br/>属:activalsize,attributes,definedsize,name,Numricscale,originalValue,precision,status,type,underlvingvalue,value<br/><br/>方法：appendchunk,getchunk<br/>集合：properties<br/><br/>ado parameter对象<br/>属性：attributes,derection,name,Numericscale,presion,size,type,value<br/>：append chunk,delete<br/><br/>ado property对象<br/>set objproperty=server.CreteObject(&quot;ADODB.Property&quot;)<br/>属性：Attributes,Name,Type,Value<br/></p>