为什么这么简单的例子都会错呢？

[meinmei]

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};server=y2;uid=;pwd=;database=sample"
Conn.Open

Conn.Close
Set Conn = Nothing
%>


报Conn.Open处出错。
请更正，谢谢！！

[coffee_cn]

access好象不是这样连接吧

[skyarrow]

access的连接：
StrSQL="DBQ="+server.mappath("data/data.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open StrSQL

[infoliny]

dbpath=server.mappath("/db/db.mdb")'数据文件路径
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath