connection >
createobject-sqlserver

Set conn=Server.CreateObject("ADODB.Connection")

设 conn 为与主机对象连结

(conn)ection
connection Data Base

Provider=SQLOLEDB; ( for SQL Server)
Initial Catalog=___ ;  ( for SQL Server)

attention::
Provider=Microsoft.Jet.OLEDR.4.0; (for Access )
Data Source= .mdb;  (for Access )

SQL server 数据库的连结
需要主机地址
数据库使用者ID
数据库使用密码
数据库名称

<%

set conn=Server.CreateObject("ADODB.Connection")

conn.open "Provider=SQLOLEDB;Data Source=___;
User Id=___;Password=___;Initial Catalog=___;"

%>
<%
Dim subSQL, ask1

ask1=request("ask")   'remark: may a submit form

subSQL= " order by c1"	
	
SQL="select * from aDB where c1='"&ask1&"' "&subSQL	

Set rs = GetSQLserverStaticRecordset( conn, SQL)


%>

Data Source=( server ); .......... maybe IP or URL
User Id=___; ......................... User ID
Password=___; ...................... Password
Initial Catalog=___;" ............... BD name

Data Source=( 主机位置 ); ........ 可为 IP or 网址
User Id=___; ......................... 使用者识别证ID
Password=___; ...................... 密码Password
Initial Catalog=___;" ............... 数据库名称