ASP与数据库的链接

[hxzjj]

哥哥姐姐们,我是一只菜鸟我在做网站中遇到了,与数据库的链接问题没有解决,现在求救!!!!

[itzhiren]

参考：www.connectionstrings.com
上面各种数据库的连接方法都有

[fantiny]

Sub readDescriptions 'Read all file descriptions in publish.mdb
Dim strProvider, sql, rs, n, i

strProvider="DRIVER=Microsoft Access Driver (*.mdb); DBQ=publish.mdb;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open strProvider,"",""
sql = "SELECT FileList.FileName, FileList.FileDescription, FileList.FilePath FROM FileList ORDER BY FileList.FileName"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
If not rs.EOF Then
rs.movelast
n = rs.recordcount - 1
rs.movefirst
For i = 0 to n
strDisplay = strDisplay + rs.Fields("FileName").Value + " " + rs.Fields("FileDescription").Value + semiColon
rs.movenext
Next
End If
End Sub

[lyq708]

第一种 - 这种方法用在ACCESS中最多

strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("aspfree.mdb"

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

conn.open strconn

第二种－这种方法用在SQL SERVER中多

strcon="Driver={SQLServer};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name

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

conn.open strconn

第三种

strconn="Driver={MicrosoftAccessDriver(*.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:

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

conn.open "Example"

第五种运用ODBC数据源，前提是你必须在控制面板的ODBC中设置数据源

set rs = server.createobject("adodb.recordset"

rs.open "tblname", "DSNName", 3, 3

[小赵]

itzhiren(itzhiren) 提供的
www.connectionstrings.com
上面各种数据库的连接方法都有

真的是个好地方哦
我 顶

[papillon_fly]

试试用Google搜索，总能解决你的难题的。