aspÔõÑùÁ¬½ÓÓй¤×÷×éȨÏÞÉèÖõÄaccessÊý¾Ý¿â
ÎÒÃÇÓÃasp+accessдһ¸öÓ¦ÓóÌÐò£¬Ï£ÍûÌá¸ßÊý¾Ý¿âµÄ°²È«ÐÔ£¬ËùÒÔ¶ÔaccessÊý¾Ý¿â½øÐÐÁËÓû§¼¶°²È«ÉèÖ㨼´ÆôÓÃÁ˹¤×÷×éȨÏÞ£©¡£ÕâÑùÒ»À´£¬µ¼ÖÂÔÀ´µÄÁ¬½Ó³ÌÐòÎÞЧÁË¡£ÏÂÃæÊÇÔÀ´µÄδÉèÖù¤×÷×éȨÏÞµÄÁ¬½Ó´úÂ룺
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/DataBase/"&strDBName&".mdb")
ÏÖÔÚÁ¬½Ó²»ÉÏÁË£¬´ÓÍøÉÏÕÒÁËһЩ²Î¿¼ÎÄÕÂÐÞ¸ÄÁ¬½Ó´úÂ룬×ÜÊDz»Äܳɹ¦£¬ÇëÄÄλ¸ßÈË°ïÎÒÖ±½ÓÐÞ¸ÄÒ»ÏÂÕâ¶Î´úÂë¡£
Ê®·Ö¸Ðл¡£
¹¤×÷×éµÄ¹ÜÀíÔ±Óû§Ãû£ºadministrator
¹¤×÷×éµÄ¹ÜÀíÔ±ÃÜÂ룺123456
¹¤×÷×éÐÅÏ¢Îļþ£ºSecurity.mdw£¨Î»ÖÃÔÚÊý¾Ý¿âͬһĿ¼֮Ï£©
ÊÔÊÔ¿´
VBScript code:
db = Server.MapPath("/DataBase/" & strDBName & ".mdb")
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & db & ";Jet OLEDB:System Database=Security.mdw;User ID=administrator;Password=123456"
²»Ðа¡£¬ÎÒ½«Õâ¶Î´úÂëÌæ»»½øÈ¥£¬»¹ÊÇûÓÐÁ¬½ÓÉÏÊý¾Ý¿â
ÕâÊDZ¨´íÄÚÈÝ£º
ADODB.Recordset '800a0bb9'
²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»òÓëÆäËû²ÎÊý³åÍ»¡£
\www\Include\DBConn.asp, line 24
ÎÒÔÚÍøÉϲéÁËһϣ¬ÆäÒâ˼¾ÍÊÇ˵Êý¾Ý¿âûÓÐÁ¬½ÓÉϵÄÒâ˼¡£
ÊDz»ÊÇÐèÒªÖ¸Ã÷Security.mdwµÄ¾ßÌ徶ÄØ£¿
Èç¹ûÁ¬²»ÉϵĵĻ°£¬Ò»°ãÓ¦¸ÃÊÇConnection´í£¬ÏÖÔ
Ïà¹ØÎÊ´ð£º
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
FSO´ò¿ªÄ¿Â¼ÎļþÁÐ±í£¬È«ÊÇͼƬ¡£
ÓÃFORÑ»·×öµÄTABLE,ÿ¸öTDÖÐÏÔʾһ¸öͼƬ£¬Í¼Æ¬³¤¿íΪ1000:560 »òÕß560:1000
ÔÚÁбíÒ³ÏÔʾСͼ,ÎÒÓõÄÊÇ
<td>
<div align=&qu ......
aspÓÐʲôºÃµÄ±à¼»·¾³Â𣿠ÓÐÄܵ÷ÊԵĻ·¾³Âð£¿
Èç¹ûÔÚsql°æ¿éÄܽâ¾ö£¬¾Í²»·Åµ½asp.netÁË
ASP
幫頂~~
ÒýÓÃ
Õâ¸ö²»ÓÃÎÊÁË°É£¬vs.net + iis
ºÜ·½±ãµÄ ......
id lbname topid ceng
1 ²úÆ·1 0 1
16 ²úÆ·2 0 1
17 ²úÆ·3 0 1
18 ²úÆ·4 0 1
19 ²úÆ·5 0& ......
ƽʱ¶¼³öÏÖÔÚIEÀï±ßµÄ£¬µ«ÏÖÔÚä¯ÀÀ·¢ÏÖ²»³öÏÖÔÚä¯ÀÀÆ÷Àï±ß¡£¸ß¼¶Àï±ßÑ¡ÖÐÁË¡°ÏÔʾ½Å±¾´íÎó...¡±µ«Ã»ÓÐÏÔʾ¡£
ÓÐûÓе÷ÊÔÆ÷£¬Ò»²½Ò»²½¸ú×ÙÖ´ÐÐÇé¿ö£¿
on error resume nextÕâÑùµÄ¶«Î÷È¥µô
»¹ÓÐÔÚIISÀï ......