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= ......
Ò»°ãÎÒÃÇ×ö³ÌÐò£¬±ÈÈçÓÃVC,¿ª·¢½çÃæÊǸöÍ·Í´µÄÎÊÌâ¡£¿ª·¢Ð§ÂÊÌ«µÍ£¬¶øÇÒ×ö³öÀ´µÄЧ¹ûҲ̫²îÁË¡£¿´ÆðÀ´Ì«²»ÃÀ¹ÛרҵÁË¡£ÁíÒ»·½ÃæHMTL×ö½çÃæÊÇÓÖ·½±ãÓÖÃÀ¹Û£¬ÇÒ»¹ÌìÉúÖ§³Öscript½Å±¾¡£·Ç³£Ç¿´ó°¡¡£ÎÒÃÇÒ»°ãʹÓÃhtmlµÄʱºò¶¼ÊÇ×öµÄB/S½á¹¹µÄÈí¼þ£¬ÐèÒªÒ»¸öWEB·þÎñÆ÷¡£ ......
ÓÉÓÚASP±à³Ì±È½Ï¼òµ¥£¬ËùÒÔÔÚÆóÒµÖÐÓкܶàµÄ¼òµ¥Ó¦Óö¼ÊÇ»ùÓÚÔÚWindows 2000 Server£«ASP£«MSSQLÉϵġ£¶øÕâÒ²ÊÇÆóÒµÏë°ÑÓ¦ÓÃÇ¨ÒÆµ½Linux»·¾³µÄÆäÖÐÒ»´óÕϰ¡£ÈôÒª´ïµ½Ç¨ÒƵÄÄ¿µÄ£¬Í¨³£ÓÐÁ½ÖÖ·½Ê½£º
ÒýÓÃ
1¡¢°ÑASP¸ÄPHP£¬MSSQL»»Mysql£¬Ð§¹ûºÃ£¬ÐÔÄÜÎȶ¨£¬¿É¿¿ÐÔÇ¿£¬µ«ºÄ·Ñʱ¼ä±È½Ï¶à£¬·ÑÓñȽϸߣ¬Óû§²»ÈÝÒ×½ÓÊÜ£»
2¡¢È ......
ÔÚ±àдASP³ÌÐòµÄʱºò£¬Í¨³£¶¼»áÓõ½<!--#include virtual/file="path/filename"-->°ÑÒ»¶ÎÏà¶Ô¶ÀÁ¢µÄÎļþ´úÂëǶÌ×µ½µ±Ç°Ò³ÃæÖÐÀ´¡£
¡¡¡¡Ê¹ÓÃ"file"µÄʱºò£¬µÈºÅºóÃæÊ¹ÓõÄÊÇÏà¶Ô·¾¶¡£Ê¹ÓÃ"virtual"µÄʱºò£¬µÈºÅºóÃæÊ¹ÓõÄÊǾø¶Ô·¾¶¡£ºÜ¶àÈ˶¼²»ÖªµÀvirtualÕâ¸ö°üº¬¾ø¶Ô·¾¶¡£ ......