ai里阵列:ASP怎么和SQL连接啊
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/03 08:00:21
各位,我不知道怎么让ASP和SQL连接啊,ASP源代码如下:
<html><body>
<%创建1个ADO CONNECTION对象
SET CN=SERVER.CREATEOBJECT("ADODB.CONNECTION")
CN.PROVIDER="SQLOLEDB"
PROVSTR="SERVER=OUTINGFEI;DATABASE=XSCJ;UID=;PWD=;"
CN.OPEN PROVSTR
RESPONSE.WRITE("<BR>" & CN.Attributes)
RESPONSE.WRITE("<BR>" & CN.CommandTimeout)
RESPONSE.WRITE("<BR>" & CN.ConnectionString)
RESPONSE.WRITE("<BR>" & CN.CursorLocation)
RESPONSE.WRITE("<BR>" & CN.DefaultDatabase)
RESPONSE.WRITE("<BR>" & CN.IsolationLevel)
RESPONSE.WRITE("<BR>" & CN.Provider)
RESPONSE.WRITE("<BR>" & CN.Version)
%>
</body></html>
<html><body>
<%创建1个ADO CONNECTION对象
SET CN=SERVER.CREATEOBJECT("ADODB.CONNECTION")
CN.PROVIDER="SQLOLEDB"
PROVSTR="SERVER=OUTINGFEI;DATABASE=XSCJ;UID=;PWD=;"
CN.OPEN PROVSTR
RESPONSE.WRITE("<BR>" & CN.Attributes)
RESPONSE.WRITE("<BR>" & CN.CommandTimeout)
RESPONSE.WRITE("<BR>" & CN.ConnectionString)
RESPONSE.WRITE("<BR>" & CN.CursorLocation)
RESPONSE.WRITE("<BR>" & CN.DefaultDatabase)
RESPONSE.WRITE("<BR>" & CN.IsolationLevel)
RESPONSE.WRITE("<BR>" & CN.Provider)
RESPONSE.WRITE("<BR>" & CN.Version)
%>
</body></html>
<%
dim conn
dim connstr
'连接数据库
strconn = "Driver={SQL Server};Description=sqldemo;SERVER=(local);UID=sa;PWD= ;DATABASE= "
set conn = server.createobject("adodb.connection")
conn.open strconn
%>
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_cc_STRING
MM_cc_STRING = "Provider=SQLOLEDB;Server=服务器名;Database=数据库名;UID=用户名;pwd=密码"
%>