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´í£¬ÏÖÔ
Ïà¹ØÎÊ´ð£º
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......
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& ......
ËÓÐaspÓòÃû²éѯµÄ¹¦ÄܵÄÔ´ÂëŶ.
ÄܸøÎÒÒ»¸öÂð,ÎÒºÜÐèҪѽ,лл¹þ
¿´¿´Õâ¸ö¡£
http://www.aspinfo.cn/article/bc/xml/17901.html
°¥.ÔõôûÈ˻ظ´Å¶
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²á ......
ÎÒÔ±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍƼöÒ»±¾ºÃÊé¸øÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ
·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à
yun
ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......