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
Ïà¹ØÎÊ´ð£º
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º private void SendMail ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸö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 ÕýÈ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......