asp Á¬½ÓoracleÎÊÌâ - Web ¿ª·¢ / ASP
Êý¾ÝÔ´Ãû³Æ Oradata Óû§Ãû£ºuser ÃÜÂëpassword ·þÎñÆ÷IP 10.160.25.15
±¾»úÉϰ²×°ÁËoracleµÄ¿Í»§¶Ë£¬Í¨Ñ¶²âÊԳɹ¦
ÇóaspÁ¬½ÓoracleÊý¾Ý¿â´úÂ룬лл°¡£¡
<%
set conn=server.createobject("adodb.connection")
newconn="Provider=OraOLEDB.Oracle.1;User ID=user;Password=password;Data Source=10.160.25.15;Persist Security Info=True"
conn.open newconn
%>
½á¹û·µ»Ø
´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E7A)
δÕÒµ½Ìṩ³ÌÐò¡£¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡£
Çë´ó¼ÒÖ¸µã°¡
ÎÒ±¾»ú°²×°ÁËoracleµÄ¿Í»§¶Ë£¬ÔÚ¡°±¾µØNET·þÎñÃûÅäÖá±Öгɹ¦Á¬½ÓÁË
ÎÊÌâÒѾ½â¾ö£¬¸üÕýData Source¶ÔÓ¦µÄÓ¦¸ÃÊÇÊý¾Ý¿âÃû³Æ
Provider=OraOLEDB.Oracle.1 »»³ÉProvider=msdaora.1 Íâ¼ÓÒ»Ïîserver=10.160.25.15
¼´OK
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
ÔõÑù½«ASP³ÌÐòת»»Îª.NET³ÌÐò ?
ÕÒ¸öÈ«²Å·Òë¡£
ÊÖ¶¯È¥Ð´
¸Ð¾õд¹ýaspµÄ£¬À´Ð´asp.net£¬ÉÏÊÖÓ¦¸Ã¿ìµã¡£
¸üÄÜÀí½âasp.netµÄһЩÄÚ²¿¼¼Êõ
asp.net¶¼±»·â×°ÁË
ÎÒÊÇ×ö.NetµÄ£¬¶ÔASPһֱû½Ó´¥µ½£¬ºÜİÉú¡£
¹« ......