AspxÓëoracleÖ®¼äµÄÁ¬½ÓÎÊÌâ
¸÷λ¸ßÊÖ¡£¡£±¾ÈËÓöµ½Ò»¸öÎÊÌ⣬·Ç³£µÄ¹ÖÒ죺
ÎÒ¿ª·¢ÁËÒ»¸ö¾ºÅĵÄÍøÕ¾¡£ÔÚvs2005 ÉϲâÊÔÍêȫûÓÐÎÊÌâ¡£µ«ÊÇ·¢²¼³öÀ´µÄ´úÂëÔÚiis Öеķ¢²¼Ëý±¨³öÁËÊý¾Ý¿âÁ¬½Óʧ°Ü£¿
µ«ÊÇÎÒÕâÌ×Êý¾Ý¿âÁ¬½Ó£¬ÎÒÒÔǰÓùýÍêȫûÓÐÎÊÌâ°¡£¿£¿
¸÷λ´ó¸çÖ¸µãÒ»ÏÂСµÜ£º
Êý¾Ý¿âÁ¬½Ó·û£ºData Source=Data;Persist Security Info=True;User ID=outln;Password=123;Unicode=True
´úÂë:
C# code:
OracleConnection Conn = GetSqlConnection("Á¬½Ó·û");
string CommTxt="sql Óï¾ä";
cmd.CommandText = CommTxt;
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
Conn.Open();--------------------¡·¡·¾ÍÊÇÔÚ´ò¿ªÁ¬½ÓµÄʱºò³ö´íµÄ
OracleTransaction Tran = Conn.BeginTransaction();
cmd.Transaction = Tran;
try
{
rInt = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception ex)
{
}
ûÓÐÈËÖªµÀÂ𣿣¿¸÷λ¸øµãÌáʾ£¡£¡
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Exception: OCIEnvCreate ʧ°Ü£¬·µ»Ø´úÂëΪ -1£¬µ«´íÎóÏûÏ¢Îı¾²»¿ÉÓá£
Ô´´íÎó:
ÐÐ 2685: sb.AppendFormat("SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from {0} {1} {2}) A WHERE ROWN
Ïà¹ØÎÊ´ð£º
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......