access数据库设了密码,用asp怎么连呀,在线等待,谢谢
<%
set conn=server.createobject("adodb.connection")
provider="provider=microsoft.jet.oledb.4.0;"
ss=jet OLEDB:Database password=hl //这里要怎么改呀
dbpath="data source="& server.mappath("db1.mdb")
conn.open provider & dbpath & ss
set rs=server.createobject("adodb.recordset")
rs.open "表2",conn,cursor,2
%>
错误显示:
Microsoft VBScript 编译器错误 错误 '800a0401'
语句未结束
/hongli/s.asp, 行4
ss=jet OLEDB:Database password="hl"
-------^