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
Ïà¹ØÎĵµ£º
Ò»°ãÎÒÃÇ×ö³ÌÐò£¬±ÈÈçÓÃVC,¿ª·¢½çÃæÊǸöÍ·Í´µÄÎÊÌâ¡£¿ª·¢Ð§ÂÊÌ«µÍ£¬¶øÇÒ×ö³öÀ´µÄЧ¹ûҲ̫²îÁË¡£¿´ÆðÀ´Ì«²»ÃÀ¹ÛרҵÁË¡£ÁíÒ»·½ÃæHMTL×ö½çÃæÊÇÓÖ·½±ãÓÖÃÀ¹Û£¬ÇÒ»¹ÌìÉúÖ§³Öscript½Å±¾¡£·Ç³£Ç¿´ó°¡¡£ÎÒÃÇÒ»°ãʹÓÃhtmlµÄʱºò¶¼ÊÇ×öµÄB/S½á¹¹µÄÈí¼þ£¬ÐèÒªÒ»¸öWEB·þÎñÆ÷¡£ ......
ÌâÍâ»°£ºÈ¥ÄêÖÁ½ñÄêÒÔÀ´£¬Â½ÐøÐ´¹ýһЩԴ´µÄÎÄÕÂÁË£¬ºÜ¶àÊǶÔÔÀ´Ëù×öÏîÄ¿µÄ×ܽᡣËùÒÔ²¢²»ÊǺÜϵͳºÜÈ«Ãæ£¬¶¼ÊÇÕë¶Ôij¸ö֪ʶµã»òÕßij¸ö¾ßÌåÓ¦ÓÃдµÄ£¬ÓÐЩÅóÓѽ¨ÒéÎÒ°Ñ×Ô¼ºµÄÌå»áд³ÉÒ»¸öϵͳµÄ£¬Õâ´ÎËãÊÇÒ»¸ö³¢ÊÔ°É£¬Ð´µÃ²»ºÃµÄµØ·½Çë´ó¼Ò¾¡Á¿Å×Î÷ºìÊÁ²»Òª¶ª×©Í·¡£
Ö®ËùÒÔ°ÑÕâ¸öϵÁнÐ×ö¡¶asp.netÒ¹»°¡·£¬ÊÇÓÐһЩÔÒ ......
Ê×ÏÈÉêÃ÷£ºÕâ¸öÊÇÎÒ×ªÔØµÄ£¬ÖÂÁ¦ÓÚΪÏñÎÒÒ»ÑùµÄÐÂÊÖÌṩ°ïÖú£¡
1¡¢IISÏÂ301ÉèÖà InternetÐÅÏ¢·þÎñ¹ÜÀíÆ÷ -> ÐéÄâĿ¼ -> ÖØ¶¨Ïòµ½URL£¬ÊäÈëÐèҪתÏòµÄÄ¿±êURL£¬²¢Ñ¡Ôñ“×ÊÔ´µÄÓÀ¾ÃÖØ¶¨Ïò”¡£
2¡¢ASPϵÄ301תÏò´úÂë
<%@ Language=VBScript %>
<%
Response.Status=”301 Moved Permanent ......
aspÔÚµ÷ ÓÃÎļþµÄʱºòÒ»°ãÓà includeÓï¾äÈ磺<! #include file="filename.asp" -->ÔÚµ÷ÓÃÎļþµÄʱºò¶ÔÓÚ¾²Ì¬ÎļþÒ»°ãÓÃiframeÓÃinclude²»Æð×÷Óã¬ÔÚһЩ¶¯Ì¬µÄÎļþÃûµÄʱºòÒ»°ãÓà Èç¹ûÒª¶¯Ì¬µÄ°üº¬ÎļþÇëʹÓà ÈçÏ£º
server.transfer Îļþ
»ò
& ......
<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_st ......