Question

寻扎代码错误asp连接数据库

set conn=server.createobject("adodb.connection")
DSNtemp = "Driver={Microsoft Access Driver (*.mdb)};"
DSNtemp = DSNtemp & "DBQ=" & server.mappath("student.mdb")
conn.open DSNtemp
上边的代码可以用
下边不可以 谁能给帮帮找找错在那里了...很白痴的问题

set conn=server.createobject("adodb.connection")
tem1 = "driver={Microsoft Access Driver (*.mdb)}};"
tem1=tem1 &"dbq="& server.mappath("student.mdb")
conn.open tem1

Answer 1

tem1 = "巧吵driver={Microsoft Access Driver (*.mdb)}};"
这一胡野句错了,多了一孝做侍个}
正确的是:
et conn=server.createobject("adodb.connection")
tem1 = "driver={Microsoft Access Driver (*.mdb)};"
tem1=tem1 &"dbq="& server.mappath("student.mdb")
conn.open tem1

Answer 2

dbpath = server.mappath("student.mdb"悄锋皮慎)
connstr = "启握晌driver={microsoft access driver (*.mdb)};dbq=" & dbpath
set conn = server.createobject("adodb.connection")
conn.open connstr