哪为大哥大姐可以告诉我连接SQL server的方法

[zhengbenben]

谁能赐教我如何连接SQL server数据库的方法,我只会连接Access 谁能告诉我阿!!

[dwxq]

http://expert.csdn.net/Expert/topic/1857/1857638.xml?temp=.5865137

[sxsgssgs]

strconn = "Driver={SQL erver};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;&_
PWD=Password;DATABASE=Database_Name

set conn = server.createobject("adodb.connection")

conn.open strconn

[lqflsh]

<%
connstr="provider=SQLOLEDB;Data Source = 数据库地址;"&"database=数据库名称;user id=用户名; password=密码"
set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open connstr
%>

[zurong]

最简单的方法
set conn=server.createobject("adodb.connection")
conn.open "DSN=数据源名；UID=用户名; PWD=密码"

[tigerwen01]

请参考：
http://www.csdn.net/develop/read_article.asp?id=18866

[zhxhjj]

第一种 - 这种方法用在ACCESS中最多
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" _
& Server.MapPath("aspfree.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn

第二种－这种方法用在SQL SERVER中多
strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;" _
&"UID=LoginID;Password=;DATABASE=Database_Name"
set conn = server.createobject("adodb.connection")
conn.open strconn

第三种
strconn="Driver={Microsoft Access Driver(*.mdb)};" _
&"DBQ=F:\Inetpub\wwwroot\somedir\db1.mdb;DefaultDir=" _
&"f:\Inetpub\wwwroot\somedir;uid=LoginID;" _
&"pwd=Password;DriverId=25;FIL=MSAccess;"
set conn = server.createobject("adodb.connection")
conn.open strconn



第四种运用系统数据源
The following uses a Data Source Name: Example
set conn = server.createobject("adodb.connection")
conn.open "Example"



第五种运用ODBC数据源，前提是你必须在控制面板的ODBC中设置数据源
set rs = server.createobject("adodb.recordset")
rs.open "tblname", "DSNName", 3, 3 第一种 - 这种方法用在ACCESS中最多
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" _
& Server.MapPath("aspfree.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn

[xuxiaoxia]

<% Set rs = Server.CreateObject("ADODB.Recordset")
SqlStr = "SELECT * FROM password "
rs.Open SqlStr,cn,1,1%>