Çó½Ì£º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Îļ
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
ÓÐÒ»¸öÀà
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=="")
{
......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......