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ÖеÄÕË»§ÊÇ·ñ¾ßÓзÃÎʴ˱íµÄȨÏÞ
È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...
µÚ¶þÕÅͼµÄ´úÂëÊǶԵģ¬×Ô¼º¼ì²éÊý¾Ý¿â£¬¿´±íÃû¶Ô²»¶Ô£¬¿´ÏÂÄãµÇ½µÄÕʺÅÏÂÃæÓÐûÓÐÕâ¸ö±í
Ê×ÏȸÐл¸÷λµÄ½â´ð£¬µ«ÊÇ»¹ÊÇû½â¾ö¡£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
Ïà¹ØÎÊ´ð£º
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......