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=___;" ............... 資料庫名稱