ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ºô¸ô¸Õ¨÷°õ¦æ¥X²{80040e21°T®§

[µo°Ý] ºô¸ô¸Õ¨÷°õ¦æ¥X²{80040e21°T®§

°T®§¡G
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/fm2011/exam/grad.asp, line 28

--------------------------------------«ö·Ó¤p»xª©¤jªº¤º®e--------------------------------------------------
'©Ó±µ¨Ó¦Ûquestion.aspªº¸ê®Æ
studentname=Request("studentname")
number=Request("number")
'¶}±Òexam.mdb¸ê®Æ®w¤¤ªºfirst¦ÒÃD¸ê®Æªí
'¦b¦¹¶}±Ò¸ê®Æ®w¬O¥Î¨ÓŪ¨úµª®×»P¼g¤J­pºâ«áªº¦¨ÁZ
'«Ø¥ß¸ê®Æ®w³sµ²ª«¥óconobject
   Set conobject = Server.CreateObject("ADODB.Connection")
'§Q¥ÎMapPath¤èªk¨ú±o¸ê®Æ§¹¾ã¯u¹ê¸ô®|      
   DBPath = Server.MapPath("/fm2011/db/exam.mdb")
'§Q¥ÎOpen¤èªk¥´¶}¸ê®Æ®w      
   conobject.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ="&DBPath
'«Ø¥ß¦s¨ú¸ê®Æ®wª«¥órecobject        
   Set recobject=Server.CreateObject("ADODB.Recordset")   
'Ū¨ú¸ê®Æªí¤º®e   
   sql="SELECT * From "&"first"&" ORDER by ÃD¸¹"
   recobject.Open sql,conobject,1,1,1                                                     ²Ä28¦æ¿ù»~°T®§
'¥ý±N¸ê®Æªíªº¸ê®Æ¿ý²¾¦Ü²Ä¤@µ§      
   recobject.MoveFirst
'¥ý±N­pºâªºÁ`¤À³]¬°¢¯   
   Score=0
   Response.Write "<div align=center><font color=green face=·s²Ó©úÅé size=6>ºô¸ô¸Õ¨÷-¦¨ÁZ§å§ï</font></div>"
'±N¥¿½Tµª®×¤Î¨ü´ú¾Ç¥Í¿ïªºµª®×¤@°_Åã¥Ü¤ñ¹ï   
   Do While Not recobject.EOF
   Sel=Request("No"&recobject(2))
   Ans=recobject(8)


----------------------------------------------------------------------------------------
§Ú¬O©óhttp://www.jabry.com/¸Óºô¯¸¥Ó½ÐªÅ¶¡ªº¡C
¸Û¼°½Ð°Ý¸Ó¦p¦ó­×§ï!?

¦^´_ 1# tony040740

¥D¾÷¤£¬O§A¦Û¤vªº©Ò¥HµLªk¦Û¦æ³]©wACCESS¸ê®Æ®wÀɮתºÅv­­
    ½Ð¸ß°Ý¥D¾÷°ÓACCESS¸ê®Æ®wÀÉ®×À³¸Ó©ñ¸m¦b­þ­Ó¯S©w¦ì¸m»P¦p¦ó¶i¦æÅv­­³]©w
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD