Çó½Ì£ºasp+oracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
ÎÒÊÇxpϵͳ£¬°²×°ºóoracle¿Í»§¶Ëºó£¬udlÎļþ²âÊÔÄܳɹ¦£¬¿Í»§¶ËÒ²ÄÜÁ¬½Óµ½·þÎñÆ÷¶ËÊý¾Ý¿â²¢Õý³£´ò¿ª¡£µ«ÊÇÔÚasp³ÌÐòÖÐÁ¬½ÓÊý¾Ý¿â²»³É¹¦£¬ÍøÒ³´ò²»¿ª¡£
´úÂëÈçÏ£º
<%
dim con
set con=server.CreateObject("ADODB.connection")
strcnn="Provider=OraOLEDB.Oracle.1;Password=rb321;Persist Security Info=True;User ID=rb;Data Source=ryoracle_192.168.1.14"
con.open strcnn
%>
´íÎóÌáʾÈçÏ£º
´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E7A)
δÕÒµ½Ìṩ³ÌÐò¡£¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡£
/cn.asp, µÚ 12 ÐÐ
ÍøÒ³²éÁ˺öà×ÊÁϾÍÊǽâ¾ö²»ÁË¡£oracle¿Í»§¶ËÈí¼þÖØ°²ÁËÈý±é£¬»¹ÊDz»ÐС£²»ÖªµÀʲôÔÒò¡£Ï£Íû¸÷λ¸ßÊÖÃǰï°ïÎÒ°¡¡£
Data Source=ryoracle_192.168.1.14
Õâ¸öÕâÑùдÊÇÕýÈ·µÄÂð£¿
ûÓÐÕÒµ½ORACLEµÄÇý¶¯£¬È·ÈÏ
%ORACLE_HOME%\oledb\lib
ÏÂÓÐûÓÐOraOLEDB*.dllÎļþ
¡°Data Source=ryoracle_192.168.1.14¡±Õâ¸öÕâÑùдӦ¸ÃÊÇûÎÊÌâµÄ°É¡£ryoracleÊÇSID£¬192.168.1.14ÊÇÖ÷»úÃû£¬Ò²¾ÍÊÇÎÒ¾ÖÓòÍøÄÚ·þÎñÆ÷IP¡£ÎÒÔÚ×Ô¼ºµçÄÔÉϰ²µÄ¿Í»§¶Ë¡£
ÒÔǰÎÒ¾ÍÊÇдµÄûÎÊÌ⣬ºóÀ´»¹ÔÁËÏÂÏµÍ³ÖØÐ°²Á˿ͻ§¶Ë¾ÍÁ¬²»ÉÏÁË¡£Çë´ó¼Ò°ïÎÒ¿´¿´ÎÊÌâ³öÔÚÄÄÀï°¡¡£
¸ãÄÇô¸´ÔÓ£¬¸Éʲô¡£¡£
¸øÄã¸ö¼òµ¥µÄ¡£
<%
dim conn
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;Data Source=XE;","yyweb","yyweb"
%>
ÎÒ°²×°ÔÚEÅ̵ģ¬Ä¿Â¼ÏÂÖ»ÓÐÕâ¸öÎļþE:\oracle\oledb\lib\OraOLEDB.lib¡£Ã»ÓÐdllÎļ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃ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
......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
Microsoft JET Database Engine '80040e07'
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......