Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çó½Ì£º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Îļ


Ïà¹ØÎÊ´ð£º

¶¯Ì¬È¡µÃaspÀà³ÉÔ±

ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ