asp源码链接acc数据库问题(解决另加分)

来源:百度知道 编辑:UC知道 时间:2024/06/27 23:09:41
conn.asp
----------------------------------------------------------
<%
dim conn
if path ="/" then
path=""
else
path="../"
end if

dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath(path &"include/connection.mdb")
conn.Open connstr
%>

<%sub show_info(newsort)
Allnewsort=GetAllChild(newsort)
if Allnewsort<>"" then
sqlstr_1="SELECT top 10 id,title,newsimg,newsdate FROM news_info WHERE newsort in (" & Allnewsort & ") ORDER BY topsign desc,id desc"
else
sqlstr_1="SELECT top 10 id,title,newsimg,newsdate FROM news_info WHERE newsort=" & newsort & " ORDER BY topsign desc,id desc"
end if
set myrs=server.CreateObject(

Locate your system''s TEMP folder:
Follow the appropriate steps for your version of Windows:
For Windows XP: On the Start menu, click Control Panel, click the Performance and Maintenance icon, click the System icon, click the Advanced tab, and then click the Environment Variables button.
For Windows 2000: right-click My Computer on your desktop, click Properties on the menu that appears, click the Advanced tab, and then click the Environment Variables button.
For Windows NT: right-click My Computer on your desktop, click Properties on the menu that appears, and then click the Environment tab.
Find the TEMP variable in the list of System variables and note the folder that your system is using.

Note An easier way to perform this task is to click Start , click Run, type %temp%, and then press Enter.
Start Windows Explorer.
In Folders view, expand the path to your temporary folder.
Right-click the folder and click Prope