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=")
......
֮ǰ×ö¹ýjspµÄÍøÕ¾¿ª·¢£¬ÓõÄÊÇstruts£¬ÏÖÔÚÓÖ×öµÄÒ»¸ö£¬¿Í»§ÒªÇóÓÃasp£¬ÎªÁ˺ÍËûÔÓеÄϵͳÅäÌ×£¬ËùÒÔû°ì·¨£¬±ØÐëÖØÐÂÔÙѧϰÁË£¬Ï£ÍûÓÐÀàËÆ¾ÀúµÄ¸ßÊÖÖ¸µãÒ»ÏÂÕâÁ½ÕßÖ®¼äÓÐʲôÏàͨµÄµØ·½£¬ÐèÒªÖØÐÂѧϰµÄÓÐÄÄЩ֪ ......
aspÓÐʲôºÃµÄ±à¼»·¾³Â𣿠ÓÐÄܵ÷ÊԵĻ·¾³Âð£¿
Èç¹ûÔÚsql°æ¿éÄܽâ¾ö£¬¾Í²»·Åµ½asp.netÁË
ASP
幫頂~~
ÒýÓÃ
Õâ¸ö²»ÓÃÎÊÁ˰ɣ¬vs.net + iis
ºÜ·½±ãµÄ ......
·þÎñÆ÷ÉϵÄËùÓеÄaspµÄÒ³ÃæµÄÄÚÈݶ¼±»É¾³ýÁË
ÁôϵľÍÖ»ÓÐÒ»¾äÂîÈ˵ϰ£¡£¿
ÎÒ½«ËùÓеÄaspÒ³ÃæÉ¾³ýÁË£¬ÉÏ´«ºó»¹ÊDZ»´Û¸ÄÁË
¿´ÁË·þÎñÆ÷ÉϵÄÎļþ£¬Ã»ÓÐÕÒµ½Òì³£µÄ£¿
Çë¸ßÊÖ¸øµãÒâ¼û£¬Ð»Ð»
ÒýÓÃ
......
ËÓÐaspÓòÃû²éѯµÄ¹¦ÄܵÄÔ´ÂëŶ.
ÄܸøÎÒÒ»¸öÂð,ÎÒºÜÐèҪѽ,лл¹þ
¿´¿´Õâ¸ö¡£
http://www.aspinfo.cn/article/bc/xml/17901.html
°¥.ÔõôûÈ˻ظ´Å¶
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²á ......