Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¡¾ÐÂÊÖÇë½Ì¡¿¿Í»§¶Ëc#Á¬½ÓoracleÊý¾Ý¿â

±¾»úÉϰ²×°ÁËoracle¿Í»§¶Ë,ÏëÁ¬½ÓÔ¶¶ËµÄoracleÊý¾Ý¿â,Ŀǰ
net·þÎñÃüÃû(test)ͨ¹ý²âÊÔ£¬
ÓÃsqlplus system/pass@testÒ²Á¬½ÓÉÏÁËÊý¾Ý¿â¡£

ÎÊÌâÊÇ£º
ÓÃodbcÅäÖÃʱ£¬Ñ¡ÓõÄÊÇoracle¿Í»§¶Ë×Ô´øµÄÇý¶¯³ÌÐò£¨oracle in OraClient10g_home1£©£¬µã»÷¡°test connection"ºó£¬³öÏÖµÄÅäÖýçÃæ£º·þÎñÃüÃûtest×Ô¶¯Ñ¡Ôñ£¬Óû§ÃûÃÜÂë¶¼²»»á´í£¬¿ÉÊÇʼÖÕ³öÀ´"Unable to connect SQLState=08004[oracle][odbc][Ora]Ora-12154:TNS:Could not resolve the connect identifier specified"

ÎÒµ½·þÎñÆ÷¶ËÓÃͬÑùµÄ·½·¨ÅäÖÃodbc£¬ÊÇÕýÈ·µÄ¡£

·þÎñÆ÷¶ËÓÐsymantec,ÄÜÍ£µÄ·þÎñ¶¼Í£ÁË£¬Ö»ÓÐÒ»¸ösymantec spbbcsvcÎÞ·¨Í£¡£

c#µÄÊý¾ÝÁ¬½Ó£º
£¨1£©Êý¾ÝԴѡȡ¡±oracleÊý¾Ý¿â¡°£¬ÅԱߵÄ˵Ã÷¡±ÊÇÁ¬½Ó9iÒÔϵÄÊý¾Ý¿â¡°£¬ÎÒËùÁ¬µÄÊý¾Ý¿âÊÇ10g,»¹ÊÇÊÔÁË£¬×îÖÕÏÔʾ¡°Ora-12154:TNS:Could not resolve the connect identifier specified¡±
£¨2£©Êý¾ÝԴѡȡÆäËû¼¸¸ö¶¼²»ÐУ¬

ËùÒÔ°ÑÏ£Íû¼ÄÍÐÔÚodbcÉÏ¡£

Çë½Ì¸÷λ¸ßÊÖ£¬ÕâÎÊÌâµ½µ×³öÔÚÄÄ£¿
²»ÖªµÀ°¡¡£¡£¡£¡£¡£¡£

²»ÖªµÀÄãµÄ·þÎñ´ò¿ªÁËûÓа¡£¡

ÇëÎÊls˵¡°·þÎñ¡±Ö¸µÄÊÇ£¿

ûÈË¡£¡£¡£¡£¡£¡£¡£¡£¡£


¿Í»§¶ËÕêÌý·þÎñÊÇ·ñ¿ªÆô°É
Òª²»Ó¦¸Ã¿ÉÒÔÁ¬½ÓµÄ°É

lsÄãºÃ¡£Ð»Ð»Äã¡£
ÎÒÓÃc#µÄ"·þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷¡°Öеġ±Êý¾ÝÁ¬½Ó¡°¡£ÓÃÕâÖÖÏòµ¼Á¬½ÓºÍÓÃ×Ö·û´®Á¬½ÓÓ¦¸ÃÊÇÒ»ÑùµÄ°É¡£ÎÒÒ²ÊÔÓÃÁË×Ö·û´®Á¬½Ó¡£³öÀ´Í¬ÑùµÄ½á¹û¡£
ÁíÍ⣬ÔÙÎʸöÎÊÌâfuwq£¬ºöÈ»·¢ÏÖ"·þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷¡°Öеġ±·þÎñÆ÷¡°£¬Ìí¼Ó·þÎñÆ÷²»³É¹¦¡£ÕâÓйØÏµÂð£¿

·þÎñÆ÷¿ªÕêÌý·þÎñ£¬¿Í»§¶ËÒ²ÒªÂð

¼


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÀûÓÃC#±àдtxtת»¯µ½xmlµÄ³ÌÐò

txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔ­Êý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ