Question

ASP连接access数据库代码问题

<%
email=request.form("email")
contents=request.form("contents")
if email = "" then email="unknown"
if contents="" then contents="none"
userip=request.servervariables("REMOTE_ADDR")
mysql="insert into reactive(email,ip,contents) values ('" & email & "','" & userip & "','" & contents & "')"
set conn=server.createobject("ADODB.Connection")
conn.open "DSN=hello;"
conn.execute mysql
%>
各位帮我看看conn.open "DSN=hello;"这里有什么错误.

Answer 1

你的CONN连接错误了。
你应该先创建CONN对名象
代码如下：
conph=Server.Mappath("data.mdb")
constring="driver={Microsoft access driver (*.mdb)};DBQ="&conph
set conn=server.createobject("adodb.connection")
conn.open constring