主题:  数据库连接的问题

咬一口

职务:普通成员
等级:1
金币:0.0
发贴:107
注册:2002/1/20 21:07:01
#12002/6/25 20:53:30
我的链接文件
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_love_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\girl\lylibrary.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
%>


改成这样的应该对吧??
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_love_STRING = "Driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.Mappath("\lylibrary.mdb")
%>


不过提示错误首页5行的错误。这个是首页的前几行的代码
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<%
set book_c = Server.CreateObject("ADODB.Recordset")
book_c.ActiveConnection = MM_love_STRING
book_c.Source = "SELECT * FROM book WHERE book_type='电脑' ORDER BY book_id DESC"
book_c.CursorType = 0
book_c.CursorLocation = 2
book_c.LockType = 3
book_c.Open()
book_c_numRows = 0
%>
<%
set book_e = Server.CreateObject("ADODB.Recordset")
book_e.ActiveConnection = MM_love_STRING
book_e.Source = "SELECT * FROM book WHERE book_type = '外语' ORDER BY book_id desc"
book_e.CursorType = 0
book_e.CursorLocation = 2
book_e.LockType = 3
book_e.Open()
book_e_numRows = 0
%>

那位帮我看看



baozai0221

职务:普通成员
等级:1
金币:0.0
发贴:66
注册:2001/7/5 21:52:24
#22002/6/26 8:06:28
MM_love_STRING = "Driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.Mappath("\lylibrary.mdb") &";"