求助asp+数据库问题
我如果要改为/database/sjzmssql.mdb 用Access要怎么改？？<%
on error resume next
strSQLServer="xxxxx"
strSQLUser="xxxx"
strSQLPassword="xxxxx"
strSQLDataBase="xxxxxx"
connstr = "driver={SQL Server};server=" & strSQLServer & ";UID=" & strSQLUser & ";PWD=" & strSQLPassword & ";database=" & strSQLDataBase & ""
set conn = server.createobject("ADODB.CONNECTION")
if err.number<>0 then
err.clear
set conn=nothing
response.write "<script>alert('创建 ADO 对象失败');</script>"
response.end
else
conn.open connstr
if err.number<>0 then
err.clear
set conn=nothing
response.write "<script>alert('SQL Server 数据库连接失败');</script>"
response.end
end if
end if
%>
<%
'sql="select * from config"
'Set rs= Server.CreateObject("ADODB.Recordset")
'rs.open sql,conn,1,1
%>
