Question

asp数据库怎么连接

asp和ACCESS怎么连接

Answer 1

给个精简版的给你
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("data/data.mdb")&""
'如你的数据库放在data/data,mdb
'response.Write(connstr)
Set conn = Server.CreateObject("ADODB.Connection")
conn.open connstr
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from mytable"
'数据库中有个mytable表，查询就是这样了
rs.open sql,conn,1,1
response.Write(rs("id"))

Answer 2

给你个经典的：
<%
Response.Charset="gb2312"
Dim Conn
Dim ConnSt
Call MyConn()
Sub MyConn()
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "DBQ="&Server.Mappath("/Data/Shop.mdb")&";DefaultDir=;Driver={Microsoft Access Driver (*.mdb)};"
If Err.Number <> 0 Then
Err.Clear
Set Conn = Nothing
Response.Write "Error"
Response.End
Else
Conn.Open ConnStr
If Err Then
Err.Clear
Set Conn = Nothing
Response.Write "Error"
Response.End
End If
End If
End sub
%>

Answer 3

连接字符串