windows server 2008 ÈÃIIS7Ö§³ÖASP Access
1. ÈÃIIS7Ö§³ÖASP
Windows VistaÖÐIIS7ÊÇĬÈϲ»°²×°µÄ£¬ËùÒÔÔÚ°²×°ÍêWindows VistaÖ®ºóÈç¹ûÐèÒª°²×°IIS7µÄ»°£¬¾ÍÒª×Ô¼º¶¯ÊÖÁË¡£°²×°µÄ²½ÖèΪ£º¿ªÊ¼¡·¿ØÖÆÃæ°å¡·³ÌÐò¡·´ò¿ª»ò¹Ø±ÕWindows¹¦ÄÜ¡·InternetÐÅÏ¢·þ Îñ(ÒÔÇ°²Ù×÷ϵͳ°æ±¾ÀïÃæµÄ"Windows components” ÔÚVistaÀïÃæ½Ð×ö"Programs and Features")¡£IIS7°²×°Ê±ÐèҪעÒâµÄÊÇ£¬Èç¹ûÐèÒªASP¡¢ASP.NETµÈµÄÖ§³Ö£¬ÊÇÐèÒª°Ñ¹¦ÄÜÄ£¿é¸ø×°Éϵģ¬Ä¬ÈÏÊDz»°²×°µÄ¡£
2. ½â¾öIIS7ÖÐ.mdbÊý¾Ý¿âÎÊÌâ¡£
ĬÈÏ×°ÍêIIS7Ö®ºó£¬Ê¹ÓÃASP³ÌÐò»á·¢ÏÖÌáʾÊý¾Ý¿âÁ¬½Óʧ°Ü£¬ÔÚÍøÉÏÕÒÁËÕÒ£¬ËµÊÇÒòΪMS JetÒýÇæ¸Ä±äÁËÁÙʱĿ¼µÄλÖ㬵«ÊÇÓÖûÓжÔÁÙʱµÄ´æȡȨÏÞ£¬µ¼ÖÂÊý¾Ý¿âʹÓÃʧ°Ü¡£
¸ø“ϵͳÅÌ:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp”Ŀ¼Ìí¼Ó Ò»¸ö“Authenticated Users”µÄÓû§£¬ÆäÖÐAppDataĿ¼ÊÇÒþ²ØµÄ£¬ÔÚ½øÈëµÄʱºò¿ÉÒÔÖ±½ÓÔÚµØÖ·À¸ÊäÈë·¾¶£¬»òÕßÔÚÎļþ¼ÐÑ¡ÏîÀïÏÔʾÒþ²ØÎļþ¡£
ÉèÖÃȨÏÞ²½Ö裺ÓÒ»÷TempÎļþ¼Ð£¬Ñ¡Ôñ“ÊôÐÔ”¡·Ñ¡Ôñ“°²È«”Ñ¡Ï¡·µ¥»÷“±à¼”¡·³öÀ´“Temp µÄȨÏÞ”¶Ô»°¿ò£¬µ¥»÷“Ìí¼Ó”£¬ÔÚÏÂÃæµÄ“ÊäÈë¶ÔÏóÃû³ÆÀ´Ñ¡Ôñ”ÖÐÊäÈëAuthenticated Users£¬È·¶¨¡··µ»Øµ½“Temp µÄȨÏÞ”£¬½«Authenticated UsersµÄȨÏÞÖеÄÍêÈ«¿ØÖƸø¹´ÉÏ£¬È·¶¨¡·È·¶¨¡£
Á´½Ó·½Ê½£º
ServerPath=Server.MapPath("/xxx.mdb")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ServerPath
Set schooldb=Server.CreateObject("Adodb.Connection")
schooldb.Open connstr
3. windows 2008 64λϵͳ½â¾öIIS7ÖÐ.mdbÊý¾Ý¿âÎÊÌâ¡£
Èç¹ûÄãʹÓÃ64λϵͳ£¬ÄÇ¿ÉÄÜÈçÉÏ°ì·¨Ò²½â¾ö²»ÁË£¬ÔÒòÊÇ64λϵͳûÓÐÌṩ64λACCESSÁ¬½ÓµÄÇý¶¯£¬°ÑÍøÕ¾¶ÔÓ¦µÄÓ¦ÓóÌÐò³ØÖÐÏîÄ¿µÄ“ÆôÓÃ32λӦÓóÌÐò”ÖÃΪ“ture”¡£ ÕâÑù¾Í¿ÉÒÔÁË¡£
Other tips in IIS7:
a. ÆôÓø¸Â·¾¶¡£
³£ÓÃµÄ ../ ¸¸Â·¾¶Ê¹ÓÃÔÚIIS7ÀïÃæÊÇĬÈϲ»Ö§³ÖµÄ¡£
ÔÚiisµÄÖ÷Ò³-->ASP -> Ë«»÷´ò¿ª-> ÆôÓø¸Â·¾¶: True
b. Ïòä¯ÀÀÆ÷·µ»Ø´íÎóÐÅÏ¢¡£
ĬÈÏÍøÒ³´úÂë³ö´íä¯ÀÀÆ÷»á³öÏÖ“An error occurred on the server when processing the URL. Please contact the system administrator”¡£
&n
Ïà¹ØÎĵµ£º
¡¡¡¡×î½üÓкܶàµÄÅóÓÑÎʵ½µ÷Óô洢¹ý³ÌµÄÎÊÌ⣬ÕâÀï¼òµ¥½éÉܼ¸ÖÖASPµ÷Óôø²ÎÊý´æ´¢¹ý³ÌµÄ·½·¨¡£
¡¡¡¡1. ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
¡¡¡¡set connection = server.createobject("adodb.connection")
¡¡¡¡connection.open someDSN
¡¡¡¡Connection.Execute "procname varvalue1, varvalue2"
¡¡¡¡'½«Ëù ......
¡¡¡¡1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡¼ÙÉèÓÐÒÔÏ´洢¹ý³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢¹ý³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE dbo.getUserList
as
set nocount on
begin
select * from dbo.[userinfo]
end
go
¡¡¡¡ÒÔÉÏ´æ´¢¹ý³ÌÈ¡µÃuserinfo±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ ......
¡¡¡¡7. ·µ»Ø¶à¸ö¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡±¾ÎÄ×îÏȽéÉܵÄÊÇ·µ»Ø¼Ç¼¼¯µÄ´æ´¢¹ý³Ì¡£ÓÐʱºò£¬ÐèÒªÒ»¸ö´æ´¢¹ý³Ì·µ»Ø¶à¸ö¼Ç¼¼¯£¬ÔÚASPÖУ¬ÈçºÎͬʱȡµÃÕâЩ¼Ç¼¼¯ÄØ£¿ÎªÁË˵Ã÷ÕâÒ»ÎÊÌ⣬ÔÚuserinfo±íÖÐÔö¼ÓÁ½¸ö×ֶΣºusertel¼°usermail£¬²¢É趨ֻÓеǼÓû§¿ÉÒԲ鿴ÕâÁ½ÏîÄÚÈÝ¡£
/*SP7*/
CREATE PROCEDURE dbo.getUserInfo
......
±éÀúXMLÎĵµ
¶ÔÓÚÏÂÃæµÄÒ»¶ÎXML´úÂ룺
XMLÎĵµÊµÀýbooks.xml£¬ÈçÏÂËùʾ£º
<?xml version="1.0" encoding="gb2312" ?>
<books>
<book status="ÒÑÊÛÍê">
<author>ÆÆÆÆ</author>
<title>XMLÈëÃÅ</title >
</book>
<book statu ......
dim dtNow
dtNow = date()
dim newDate
newDate = year(dtNow) & "-" & right("0" & month(dtNow),2) & "-" & right("0" & day(dtNow),2)
Õâ¸ö×Ô¶¯½«2010-4-20 ת»¯Îª 2010-04-20
http://w.sogou.com/question/99319695.html ......