Çó½Ì£º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Îļ
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......