Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

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

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

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

[Ô­´´] 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ºÅ