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 ......
Ä¿Ç°ÔÚInternetÉϹ㷺ʹÓõĺǫ́¼¼ÊõÖÖÀà·±¶à£¬Ó¦ÓñȽϹ㷺µÄÓÐCGI£¬ASP£¬PHP£¬JSP/JavaServlet£¬ColdFusionµÈ¡£ÔÚÕâÒ»½ÚÀÖ÷Òª½éÉܼ¸ÖÖÔÚ¹úÄÚÓ¦ÓñȽϹ㷺µÄºǫ́ÓïÑÔ¡£
¡¡¡¡CGI£¬È«³ÆΪCommon Gateway Interface
¡¡¡¡CGI¾ÍÊǹ«¹²Íø¹Ø½Ó¿Ú (Common Gateway Interface) µÄËõд¡£ËüÊÇ×îÔç±»ÓÃÀ´½¨Á¢¶¯Ì¬ÍøÕ¾µÄºǫ́¼¼Êõ ......
ÓÉÓÚ³ÌÐòÐèÒª°ÑSQL SERVER ÀïµÄÊý¾Ýµ¼Èëµ½ACCESSÀï.
¸Õ¿ªÊ¼Ê¹ÓÃDataSetÀ´Ñ»·.
Êý¾ÝÁ¿ÉÙµÄʱºò»¹Ëã¿ÉÒÔÓ¦¸¶µÄ¹ýÀ´.
µ«µ±Êý¾Ý¶àµÄʱºò.
»á±¨´í"λÖôíÎó"
ÔÚÍøÉÏËÑÑ°Ò»·¬.ÕÒµ½Ò»¸ö·½·¨.
ʹÓÃinsert into openrowset
½Ó×Å´íÎóÒ»¸ö½ÓÒ»¸öµÄÀ´..
"²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£"
"δÄÜÕÒµ½ OLE DB Ì ......
if (currentPage ==1) {
//Èç¹ûµ±Ç°Ò³ÎªµÚ1Ò³
sql ="select top "+pageSize+" * from Table";
} else {
int start =(currentPage -1)*pageSize;
sql ="select top "+pageSize+" * from Table where ID not in (select top "+start+" ID from Table)";
} ......