C#¿ª·¢oracleµÄÎÊÌâ
±¾²ËÄñÔÚÁ·Ï°Ê¹ÓÃvs2005¿ª·¢oracle10gÊý¾Ý¿âʱ£¬³öÏÖÏÂÃæµÄ´íÎ󣬴Óû½Ó´¥¹ýorcale£¬Ï£Íû¸÷λ´óÏÀ°ïСµÜ½â´ðÒɻ󡫡«Ð»Ð»£¡ µ±"select * from companyinform"ȱÉÙ¡°;¡±Ê±£¬´íÎóÌáʾÈçÏÂͼ£º PS£ºoracleÊý¾Ý¿âºÍvs2005¶¼×°ÔÚͬһ·þÎñÆ÷ÉÏ£¬·þÎñÆ÷win2003SP2
Ï£ÍûºÃÐÄÈ˰ïÐÂÊÖÏ¡«¡« select * from dbo.companyinform , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£ Ã²ËÆÃ»ÓÐÕâ¸ö±í ¡£¡£¡£ sqloda.Fill(xxx,xxx) ΪʲôÄãÒªÌîµÚ¶þ¸ö²ÎÊý£¿ Ö»ÓÐdatasetÀïÃæÓÐÃûΪxxxµÄtableʱ²ÅÄÜÕâÑùÓÃ°É ×¢ÒâÄãµÄconnStringÖеÄÕË»§ÊÇ·ñ¾ßÓзÃÎʴ˱íµÄȨÏÞ È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...ÒýÓà select * from dbo.companyinform , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£ µÚ¶þÕÅͼµÄ´úÂëÊǶԵģ¬×Ô¼º¼ì²éÊý¾Ý¿â£¬¿´±íÃû¶Ô²»¶Ô£¬¿´ÏÂÄãµÇ½µÄÕʺÅÏÂÃæÓÐûÓÐÕâ¸ö±íÒýÓà ȥµô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É... ÒýÓà 2 Â¥ kyoybs µÄ»Ø¸´:select * from dbo.companyinform , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£ Ê×ÏȸÐл¸÷λµÄ½â´ð£¬µ«ÊÇ»¹ÊÇû½â¾ö¡£oracleÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®Îª£º connstring = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=JSC)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=WebServiceTest)));User Id=wsdb;Password=ws
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£» QQ£º413763818£» eamil:swebook@126.com ÍøÉÏÒ»´ó¶Ñ£¡ www.51aspx.com ȥϠ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......