ÊÖ»úÕ¾
ÍøÍ¨·ÖÕ¾
µçÐÅÖ÷Õ¾
ÃÜ¡¡Âë:
Óû§Ãû£º
µ±Ç°Î»Öà : Ö÷Ò³>ÍøÂç±à³Ì>Asp±à³Ì>Áбí

PRB£ºASP ·µ»Ø¡°Operation Must Use an Updateable Query¡±£¨²Ù×÷±ØÐëʹÓÿɸüеIJéÑ

À´Ô´£º»¥ÁªÍø ×÷Õߣºwest263.com ʱ¼ä£º2008-02-23
Î÷²¿ÊýÂë-È«¹úÐéÄâÖ÷»ú10Ç¿£¡40ÓàÏîÐéÄâÖ÷»ú¹ÜÀí¹¦ÄÜ,È«¹úÁìÏÈ!Ë«Ïß¶àÏßÐéÄâÖ÷»úÄϱ±·ÃÎʳ©Í¨ÎÞ×è!Ãâ·ÑÔùËÍÆóÒµÓʾÖ,.CNÓòÃû,×ÔÖú½¨Õ¾480ÔªÆð,Ãâ·ÑÊÔÓÃ7Ìì,ÂúÒâÔÙ¸¶¿î! P4Ö÷»ú×âÓÃ799Ôª/ÔÂ.Ô¸¶Ãâѹ½ð!

Ö¢×´
µ±Äú½« ActiveX Êý¾Ý¶ÔÏó (ADO) Óë Active Server Pages (ASP) Ò»ÆðʹÓÃʱ£¬¿ÉÄÜ»áÓöµ½ÒÔϳ£¼û´íÎó£º
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updateable query.

Ô­Òò
±¾ÎIJûÊöµ¼Ö´˴íÎóµÄËÄÖÖÖ÷ÒªÔ­Òò¼°ÏàÓ¦µÄÌæ´ú·½·¨¡£¾¡¹Ü±¾ÎÄÌÖÂÛµÄÊÇ Microsoft Access Êý¾Ý¿â£¬µ«´Ë´¦ÌṩµÄÐÅÏ¢Ò²ÊÊÓÃÓÚÆäËûÀàÐ͵ÄÊý¾Ý¿â¡£

½â¾ö·½°¸
µ±ÄúµÄ½Å±¾ÊÔͼִÐиüлòÖ´Ðлá¸ü¸ÄÊý¾Ý¿âÖеÄÐÅÏ¢µÄÆäËûijÖÖ²Ù×÷ʱ£¬Í¨³£»áÓöµ½´Ë´íÎó¡£³öÏÖ´Ë´íÎóµÄÔ­ÒòÊÇ ADO ÓÉÓÚÒÔÏÂijÖÖÔ­Òò¶øÎÞ·¨Ð´ÈëÊý¾Ý¿â£º

1. ×î³£¼ûµÄÔ­ÒòÊÇ Internet À´±öÕÊ»§£¨IUSR_MACHINE£¬Ä¬ÈÏÇé¿öϸÃÕÊ»§ÊôÓÚ¡°Everyone¡±×飩¶ÔÊý¾Ý¿âÎļþ (.mdb) ûÓÐдȨÏÞ¡£Òª½â¾ö´ËÎÊÌ⣬ÇëʹÓà Explorer Öеġ°°²È«¡±Ñ¡ÏÀ´µ÷Õû´ËÎļþµÄÊôÐÔ£¬ÒÔ±ã Internet À´±öÕÊ»§¾ßÓÐÕýÈ·µÄȨÏÞ¡£

×¢Ò⣺ÔÚ½« Microsoft Access Êý¾Ý¿âÓë ADO Ò»ÆðʹÓÃʱ£¬»¹±ØÐëÊÚÓè Internet À´±öÕÊ»§¶Ô°üº¬ .mdb ÎļþµÄĿ¼µÄдȨÏÞ¡£ÕâÊÇÒòΪ Jet »á´´½¨Ò»¸öÓÃÓÚ´¦ÀíÊý¾Ý¿âËø¶¨µÄ .ldb Îļþ¡£ÓÉÓÚ Jet ¿ÉÄÜ»áÔÚ¡°Temp¡±Ä¿Â¼Öд´½¨ÁÙʱÎļþ£¬Òò´ËÄú¿ÉÄÜ»¹ÐèÒªÊÚÓè¶Ô¸ÃÎļþ¼ÐµÄ¶Á/дȨÏÞ¡£
2. ³öÏÖ´Ë´íÎóµÄµÚ¶þ¸öÔ­ÒòÊÇÊý¾Ý¿â²»ÊÇʹÓþßÓÐдȨÏÞµÄÕýȷģʽ´ò¿ªµÄ¡£Èç¹ûÄú¶Ô Connection ¶ÔÏóÖ´ÐÐ Open ²Ù×÷£¬ÔòӦʹÓà Mode ÊôÐÔָʾ¶Ô¸ÃÁ¬½ÓËùÓµÓеÄȨÏÞ£¬ÈçÏÂËùʾ£º
SQL = "UPDATE Products Set UnitPrice = 2;"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Mode = 3 '3 = adModeReadWrite
Conn.Open "myDSN"
Conn.Execute(SQL)
Conn.Close

×¢Ò⣺ĬÈÏÇé¿öÏ£¬MODE ÉèÖÃΪ 0(adModeUnknown)£¬¸Ãֵͨ³£ÔÊÐí¸üС£
3. ³öÏÖ´Ë´íÎóµÄÁíÒ»¸öÔ­ÒòÊÇ£ºÔÚ ODBC ¹ÜÀíÆ÷ÖУ¬DSN µÄ¡°Ñ¡ÏҳÖеġ°Ö»¶Á¡±ÉèÖÿÉÄܱ»Ñ¡ÖС£
4. ×îºóÒ»¸öÎÊÌâºÍÌæ´ú·½·¨ÊÊÓÃÓÚËùÓÐ SQL Êý¾ÝÔ´¡£Î¥·´Êý¾Ý¿âµÄÒýÓÃÍêÕûÐ﵀ SQL Óï¾ä¿ÉÒÔµ¼Ö³öÏÖ´Ë´íÎó¡£ÏÂÃæÊÇһЩ×î³£¼ûµÄʧ°ÜµÄ²éѯ£º
• ÆäÖÐ×î¼òµ¥µÄÒ»×é²éѯÊÇÒÔÏÂÄúÎÞ·¨¸ü¸ÄµÄ²éѯ£ºUniqueValue ÊôÐÔÉèÖÃΪ Yes µÄ½»²æ±í²éѯ¡¢SQL ´«µÝ²éѯ¡¢ÁªºÏ²éѯ»ò¸üУ¨¼´Éú³É±í£©²Ù×÷²éѯ¡£


• ÁíÒ»Öַdz£³£¼ûµÄÔ­ÒòÊÇÁª½Ó°üº¬µÄÁ´½Ó ODBC ±íµÄË÷Òý²»ÊÇΨһµÄ¡£ÔÚÕâÖÖÇé¿öÏ£¬SQL ÎÞ·¨±£Ö¤±íÖеļǼÊÇΨһ£¬¸Ã±íÖÐ×ֶεÄÖµ½«Ëæ²éѯ·¢Éú¸ü¸Ä¡£


• ÓÐÒ»ÖÖÔ­ÒòȷʵÓпɿ¿µÄÌæ´ú·½·¨¡£Èç¹ûÄú³¢ÊÔ¸üС°Ò»¶Ô¶à¡±²éѯµÄ¡°Ò»¡±·½µÄÁª½Ó×ֶΣ¬²Ù×÷½«»áʧ°Ü£¬³ý·ÇÄúÆôÓü¶Áª¸üС£ÒòΪÕâÑùÄú¾Í¿ÉÒÔ½«ÒýÓÃÍêÕûÐÔίÍиø JET ÒýÇæ¡£

ÎÄÕÂÕûÀí£ºÎ÷²¿ÊýÂë--רҵÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú·þÎñ
http://www.west263.com
ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúÒª×ªÔØ±¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!