Çó½Ì£º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Îļ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......