ASPÁ¬½Ó´øÃÜÂëµÄACCESSÊý¾Ý¿â ´úÂë¸ñʽ
Ò»:
1 ÃÜÂëÊÇÊý¾Ý¿âÃÜÂ룺
ÉèÖÃÊý¾Ý¿âÃÜÂ룬´ò¿ªÃÜÂëΪ555´ò¿ªÊ±ÐèҪʹÓÃ
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=555"
2 Óû§×飺
Óû§ÃûΪ admin ÃÜÂëΪ rr Óû§×éÎļþΪ c:\system.mdw£¬´ò¿ªÊ±ÐèҪʹÓÃ
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=rr;Jet OLEDB:Database Password=1;Jet OLEDB:System database=c:\system.mdw"
¶þ:
--ADOÁ¬½Ó´®(´øMDWµÄÁ¬½Ó´®)£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Test.MDB;User ID=admin;Password=;Jet OLEDB:Database Password=;Jet OLEDB:System database=D:\Test_Sys.MDW;Persist Security Info=False
ÆäÖеÚÒ»¸öpasswordΪAccessµÄÓû§adminµÄÃÜÂ룬µÚ¶þ¸öΪAccessÊý¾Ý¿âµÄÃÜÂë
Ïà¹ØÎĵµ£º
ÓÃASPʵÏÖÖ§³Ö¸½¼þµÄEMailϵͳ(2)
¡¡¡¡²»¹ýÕâ½ö½öÖ»Êǵõ½ÁË·¢ËÍÕßµÄipµØÖ·ºÍmacµØÖ·£¬¶øÇÒ½ûÖ¹Óû§×Ô¼º¸ü¸Ä×Ô¼ºipµØÖ·µÄ´úÂ룬ÒòΪÎÒÃǵÄϵͳÊÇÐèÒª¶Ô¸öÈËÐÞ¸ÄipµÄÐÐΪ½øÐнûÖ¹µÄ¡£
£¼%
strIP = Request.ServerVariables("REMOTE_ADDR")
Set net = Server.CreateObject("wscript.network")
Set sh = S ......
ºǫ́Êý¾Ý¿â£º
[Microsoft Access]
Óë
[Microsoft Sql Server]
¸ü»»Ö®ºó£¬ASP´úÂëӦעÒâÒªÐ޸ĵÄһЩµØ·½£º
[Ò»]Á¬½ÓÎÊÌ⣨¾ÙÀý)
[Microsoft Access]
constr = "DBQ=c:\data\clwz.mdb; DRIVER={Microsoft Access Driver (*.mdb)}"
[Microsoft Sql Server]
constr = "DRIVER={SQL Server};SERVER=host;DATA ......
//¸ù¾ÝÖ÷¼üÀ´É¾³ý±íÖеÄÊý¾Ý¡£
//ɾ³ý
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
OleDbConnection sqlConnection = new OleDbConnection(GetConnection());
& ......
ÉÏÍøgoogleÁËһϣ¬¿´Á˼¸¸öÈ˵ÄÌû×Ó£¬´ó¸ÅÃ÷°×ÁËÊÇʲôÒâ˼¡£
Èç¹ûÒ»¸öÓû§µÄIPÔÚ×î½üÒ»¶Îʱ¼äÄÚ¶à´ÎÓÉÓÚÃÜÂë´íÎóµÇ¼ʧ°Ü£¬ÄÇôϵͳ¾Í»á°ÑÕâ¸öÓû§·âµô£¬submit»òÕßmail¾Í»áÌáʾAccess denied.
Õâ±¾ÊÇÒ»¸ö°²È«´ëÊ©£¬µ«ÊÇûÏëµ½poj¿ªÍ¨ËùνµÄ"¹«Íø¼ÓËÙ"Ö®º ......
Êé½ÓÉÏÎÄ£¬Ö±½Ó´Ó×Ö·û´®·µ»Ø¶ÔÏ󣬴˴θüУ¬ÊµÏÖÁË·µ»Ø¶ÔÏóµÄ×Ô¶¯»¯£¬ÎÞÐèÔÚÉùÃ÷ʵÌåÀà¡£µ«Õâ¸öº¯ÊýÖ»ÊʺÏÒ³ÃæÉùÃ÷¼¸¸ö¶ÔÏó£¬ÅúÁ¿¶ÔÏ󣬱ÈÈ缸°Ù¸ö£¬ÍƼöʹÓÃÏÂÒ»ÎÄËùʹÓú¯Êý¡£
º¯ÊýºÜ¼òµ¥£¬²»½âÊÍ£¬Ö±½ÓÌù´úÂë¡£
option explicit
'·µ»Ø¶ÔÏóµÄº¯Êý
function getObj(byval str)
dim classname,itemlist,i
cl ......