asp连接access数据库和sql server数据库的常用语句
【建站技术】
1. ASP与Access数据库连接：
-----------------------------------------------------------
<%@ language=VBscript%>
<%
dim conn,mdb,connstr
mdb=server.mappath("数据库名称.mdb")
set conn=server.createobject("adodb.connection")
connstr="driver={microsoft access driver(*.mdb)};uid=admin;pwd=数据库密码;dbq="&mdb
conn.open connstr
%>
------------------------------------------------------------
<%@ language=VBscript%>
<%
dim conn,mdb,connstr
mdb=server.mappath("数据库名称.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&mdb
conn.Open connstr
%>
------------------------------------------------------------
2. ASP与SQL数据库连接：
------------------------------------------------------------
<%@ language=VBscript%>
<%
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;DATABASE=数据库名称;User ID=UserName;PWD=数据库密码"
%>
------------------------------------------------------------
<%@ language=VBscript%>
<%
dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={SQL Server};server=SQL服务器名称;uid=UserName;pwd=数据库密码;database=数据库名称"
%>
------------------------------------------------------------
建立记录集对象：
recordset.Open Source,ActiveConnection,CursorType,LockType,Options
如：
set rs=server.createobject("adodb.recordset")
rs.open SQL语句,conn,1,3