为什么数据库老连不上！！

[ozeo]

为什么数据库老连不上，我用的ACCESS数据库放在ASP文件同一目录直接访问。大家能否给个例子谢啦.

[lun2001]

ACCESS数据库放在哪都没问题，只要设置好ODBC

set conn = server.createobject("adodb.connection")
'dsn 用odbc数据源的名字
conn.open "dsn=your dsn"

[freezwy]

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data.mdb")

[tripofdream]

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("data.mdb")

[hydnoahark]

出什么错

[qinli]

set rs=server.createobject("adodb.recordset")
sql="select * from liuyan"
rs.open sql,myconn,1,1
另外myconn.inc文件是这样的：
<%
dim myconn,connstr
connstr="DBQ="+server.mappath("db/product.mdb")+ _
";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};" + _
"DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" + _
"MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;" + _
" SafeTransactions=0;Threads=3;UserCommitSync=Yes;"
set myconn=server.createobject("ADODB.CONNECTION")
myconn.open connstr

%>