access_conn.asp

一个简单的ASP和ACCESS连接的范例,实现简单的生日登记显示功能.

<%
On Error Resume Next
set conn=server.createobject("adodb.connection")
'response.write Request.ServerVariables("APPL_PHYSICAL_PATH") & "db\employ_birthday.mdb"
' APPL_PHYSICAL_PATH
' 与应用程序元数据库路径相应的物理路径。
dbPath = Request.ServerVariables("APPL_PHYSICAL_PATH") & "empoly_birth\employ_birthday.mdb"
conn.open "driver={microsoft access driver (*.mdb)};dbq=" & dbPath
   if err then
      conn.Close 
      Response.Write "连接数据库失败！"
      Response.End
   end if


%>