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"
¡¡¡¡'½«Ëù ......
Ò»:
<FORM name=RedForm action=# >
<INPUT name=textfield2>
<INPUT type=image height=19 width=53 src="xxx.gif" align=absMiddle border=0 name=RedImg onclick="this.form.submit()">
<INPUT type=image height=19 width=53 src="xxx.gif" align=absMiddle border=0 name=RedImg3 onclick= ......
ʵÏÖÁ˼òµ¥µÄÊý¾Ý¿âÁ¬½Ó£¬µÃµ½¼Ç¼¼¯£¬µÃµ½¶þάÊý×飬ִÐÐij¸öÓï¾ä£¬ÆäʵÕâ¸öÀà¿ÉÒÔ¼ÌÐøÀ©³ä£¬±ÈÈçÏȶÁÈ¡±äÁ¿£¬µÃµ½Ö´ÐдÎÊý£¬¼òµ¥·ÖÒ³µÈµÈ¡£¡££¬Æª·ùÓÐÏÞ£¬×Ô¼ºÀ©³ä
'----------------------------------------------
'Êý¾Ý¿â²Ù×÷
'----------------------------------------------
'¼ò»¯µÄÊý¾ÝÀà
Class dbconn
pub ......
ÌâÍâ»°£ºÈ¥ÄêÖÁ½ñÄêÒÔÀ´£¬Â½Ðøд¹ýһЩԴ´µÄÎÄÕÂÁË£¬ºÜ¶àÊǶÔÔÀ´Ëù×öÏîÄ¿µÄ×ܽᡣËùÒÔ²¢²»ÊǺÜϵͳºÜÈ«Ã棬¶¼ÊÇÕë¶Ôij¸ö֪ʶµã»òÕßij¸ö¾ßÌåÓ¦ÓÃдµÄ£¬ÓÐЩÅóÓѽ¨ÒéÎÒ°Ñ×Ô¼ºµÄÌå»áд³ÉÒ»¸öϵͳµÄ£¬Õâ´ÎËãÊÇÒ»¸ö³¢ÊÔ°É£¬Ð´µÃ²»ºÃµÄµØ·½Çë´ó¼Ò¾¡Á¿Å×Î÷ºìÊÁ²»Òª¶ª×©Í·¡£
Ö®ËùÒÔ°ÑÕâ¸öϵÁнÐ×ö¡¶asp.netÒ¹»°¡·£¬ÊÇÓÐһЩÔÒ ......
ÔÚ±àдASP³ÌÐòµÄʱºò£¬Í¨³£¶¼»áÓõ½<!--#include virtual/file="path/filename"-->°ÑÒ»¶ÎÏà¶Ô¶ÀÁ¢µÄÎļþ´úÂëǶÌ×µ½µ±Ç°Ò³ÃæÖÐÀ´¡£
¡¡¡¡Ê¹ÓÃ"file"µÄʱºò£¬µÈºÅºóÃæʹÓõÄÊÇÏà¶Ô·¾¶¡£Ê¹ÓÃ"virtual"µÄʱºò£¬µÈºÅºóÃæʹÓõÄÊǾø¶Ô·¾¶¡£ºÜ¶àÈ˶¼²»ÖªµÀvirtualÕâ¸ö°üº¬¾ø¶Ô·¾¶¡£ ......