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³ÌÐò¿ª·¢¹ý³ÌÖУ¬½á¹¹Êý¾ÝµÄ´æ´¢Ò»Ö±ÊǸöÎÊÌ⣬aspµÄÊý×éÒ»Ö±ºÜÈõ£¬¶øÇÒ²»ÄÜ×Ô½âÊÍ£¬ ......
¡¡¡¡×î½üÓкܶàµÄÅóÓÑÎʵ½µ÷Óô洢¹ý³ÌµÄÎÊÌ⣬ÕâÀï¼òµ¥½éÉܼ¸ÖÖASPµ÷Óôø²ÎÊý´æ´¢¹ý³ÌµÄ·½·¨¡£
¡¡¡¡1. ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
¡¡¡¡set connection = server.createobject("adodb.connection")
¡¡¡¡connection.open someDSN
¡¡¡¡Connection.Execute "procname varvalue1, varvalue2"
¡¡¡¡'½«Ëù ......
Top-CMSÖ÷ÒªÌØµã£º
1.ϵͳ²ÉÓÃASP+COM¼¼Êõ¿ª·¢£¬Ò»·½Ãæ×î´ó³Ì¶È±£ÕÏϵͳ°²È«ÐÔ£¬ÁíÒ»·½Ã漫´óµÄÌá¸ßϵͳÔËÐÐЧÂÊ¡£
2.ϵͳÍêÈ«»ùÓÚB/Sģʽ¹¹½¨£¬Ö»ÒªÔÚ·þÎñÆ÷Éϰ²×°Á˱¾ÏµÍ³£¬¿Í»§»ú²»ÐèÒª°²×°ÆäËûÈí¼þ£¬Ö±½ÓʹÓÃIE±ã¿Éä¯ÀÀ¡£
3.ϵͳ±¾Éí¼¯³ÉÖîÈ繫¸æ¡¢×¨Ìâ¡¢ÔÚÏßµ÷²é¡¢Óû ......
×î½ü°ïÀÏʦ×öÒ»¸ö¹ú¼Ê»áÒéµÄÍøÕ¾£¬ÓÃasp×öµÄ£¬ËäÈ»ºÜ¼òµ¥£¬µ«ÅäÖõĹý³ÌÒ²ÓÐЩ¶«Î÷ÐèҪעÒâµÄ£¬·ñÔò¼ì²é²»³öÀ´£¬ºÜÀË·Ñʱ¼ä£¬×¢ÒâÊÂÏîÂÞÁÐÈçÏ£º
1. ÍøÕ¾µÄȨÏÞÉ趨£¬Ä¬ÈÏÇé¿öÏ£¬²»ÄÜ·ÃÎÊ“¸¸Îļþ¼Ð”£¬ÕâʱºòÐèÒªÔÚiisµÄaspÑ¡ÏîÖÐÉèÖ㬓´ò¿ª¹¦ÄÜ”->“ÆôÓø¸Â·¾¶”
2. Êý¾Ý¿âÓÐʱºò ......
aspÔÚµ÷ ÓÃÎļþµÄʱºòÒ»°ãÓà includeÓï¾äÈ磺<! #include file="filename.asp" -->ÔÚµ÷ÓÃÎļþµÄʱºò¶ÔÓÚ¾²Ì¬ÎļþÒ»°ãÓÃiframeÓÃinclude²»Æð×÷Óã¬ÔÚһЩ¶¯Ì¬µÄÎļþÃûµÄʱºòÒ»°ãÓà Èç¹ûÒª¶¯Ì¬µÄ°üº¬ÎļþÇëʹÓà ÈçÏ£º
server.transfer Îļþ
»ò
& ......