1、用DSN连接
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"
2、不用DSN连接:
Dim conn,Strconn
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={SQL Server};SERVER=SName;UID=USER;PWD=pwd;DATABASE=DBname"
conn.open Strconn
3、SQL server OLE DB连接方法
Dim adocon
set adocon=Server.Createobject("adodb.connection")
adocon.open"provider=SQLOLEDB.1;Data Source=RITANT4;"& _
"user ID=***;Password=***;"& _
"inital Catalog=数据库名"
<%
Dim startime
Dim con
'DB连接
Dim connstr
'数据库连接字符串
Dim endtime
Dim db,pass_word,User_ID,Data_Source
' db 数据库名称 默认安装的不要改,pass_word=帐号密码 要改,User ID=登陆帐号 默认安装的不要改'Data Source=服务名称或者ip 要改
startime=timer()
db="要连接的数据库名"
Pass_word="SQL密码"
User_ID="sa"
Data_Source="localhost"
Set con = Server.CreateObject("ADODB.Connection")
connStr="DRIVER={SQL Server};SERVER=" & Data_Source & "; uid=" & User_ID & ";pwd=" & Pass_word & ";database=" & db
Con.ConnectionTimeout= 0
'定义连接数据源时的最长等待时间,0 表示没有时间限制
Con.CommandTimeout = 0
'设定数据源查询操作时间
con.Open connstr
sub CloseCn()
con.close
set con=nothing
end sub
%>
<%
'option explicit
Dim DBType
DBType=0 '0为Access数据库,1为MSSQL数据库
If(DBType=0) Then
call ConnectionDatabase
elseif(DBType=1) then
call ConnectionDate
end if
sub ConnectionDatabase
Dim Connstr
Db="data/fc.mdb"
Connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
Set conn=Server.CreateObject("ADODB.Connection")
conn.open Connstr
If Err then
err.Clear
Set Conn=Nothing
Response.Write"数据库连接出错,请检查连接字符窜。"
Response.End
End if
End sub
sub ConnectionDate
Dim Connstr
SqlDataName="uzfc" '数据库名称
SqlPassword="198183" '连接密码
SqlUsername="sa" '连接用户名
SqlLocalName="(LOCAL)" '服务器名或IP地址
Connstr = "Provider=Sqloledb; User ID="&SqlUsername&"; Password="&SqlPassword&"; Initial Catalog="&SqlDataName&"; Data Source="&SqlLocalName&";"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open Connstr
If Err then
err.Clear
Set Conn=Nothing
Response.Write"数据库连接出错,请检查连接字符窜。"
Response.End
End if
End sub