asp Á¬½ÓoracleÎÊÌâ - Web ¿ª·¢ / ASP
Êý¾ÝÔ´Ãû³Æ Oradata Óû§Ãû£ºuser ÃÜÂëpassword ·þÎñÆ÷IP 10.160.25.15
±¾»úÉϰ²×°ÁËoracleµÄ¿Í»§¶Ë£¬Í¨Ñ¶²âÊԳɹ¦
ÇóaspÁ¬½ÓoracleÊý¾Ý¿â´úÂ룬лл°¡£¡
<%
set conn=server.createobject("adodb.connection")
newconn="Provider=OraOLEDB.Oracle.1;User ID=user;Password=password;Data Source=10.160.25.15;Persist Security Info=True"
conn.open newconn
%>
½á¹û·µ»Ø
´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E7A)
δÕÒµ½Ìṩ³ÌÐò¡£¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡£
Çë´ó¼ÒÖ¸µã°¡
ÎÒ±¾»ú°²×°ÁËoracleµÄ¿Í»§¶Ë£¬ÔÚ¡°±¾µØNET·þÎñÃûÅäÖá±Öгɹ¦Á¬½ÓÁË
ÎÊÌâÒѾ½â¾ö£¬¸üÕýData Source¶ÔÓ¦µÄÓ¦¸ÃÊÇÊý¾Ý¿âÃû³Æ
Provider=OraOLEDB.Oracle.1 »»³ÉProvider=msdaora.1 Íâ¼ÓÒ»Ïîserver=10.160.25.15
¼´OK
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸö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 ÕýÈ ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......