ASP 中连接 Mssql的几种方法

方法一:

1   
2dim conn   
3set conn=server.createobject("ADODB.connection")   
4conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=db.janusgroup.cn;UID=web286418;PWD=j2z0h1v2;DATABASE=www_janusgroup_cn"   
5Set conn = Server.CreateObject("ADODB.Connection")   
6DSNtemp="DRIVER={SQL Server};SERVER=db.janusgroup.cn;UID=web286418;PWD=j2z0h1v2;DATABASE=www_janusgroup_cn"   
7conn.open DSNtemp

方法二:

 1   
 2option explicit   
 3dim startime   
 4dim conn   
 5dim connstr   
 6dim db,pass_word,User_ID,Data_Source   
 7startime=timer()   
 8db="www_db_cn" '数据库名称   
 9Pass_word="0h1v2" 'Password=帐号密码   
10User_ID="web2-sql8" 'User ID=登陆帐号   
11Data_Source="100.100.100.100" 'Data Source=服务名称或者ip 
12
13Set conn = Server.CreateObject("ADODB.Connection")   
14connStr="Provider=SQLOLEDB.1;Password='"&pass_word&"';Persist Security Info=True;User ID='"&User_ID&"';Initial Catalog='"&db&"';Data Source='"&Data_Source&"'"   
15conn.Open connstr   
16function CloseDb   
17Conn.close   
18Set conn = Nothing   
19End Function