conn

asp与SQL相连接:
<%
on error resume next
response.buffer=true
set conn=server.createobject("adodb.connection")
connstr="provider=sqloledb;data source=(local);lnitial catalog=test;user id=sa;password=yanyan;"
conn.open connstr
%>


与ACCESS连接
<%
on error resume next 
 response.buffer=true
 db="starnitouzi.mdb"
 set conn=server.createobject("adodb.connection")
 connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath(db)
 conn.open connstr
%>