¡¾ÐÂÊÖÇë½Ì¡¿¿Í»§¶Ë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£¬ºöÈ»·¢ÏÖ"·þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷¡°Öеġ±·þÎñÆ÷¡°£¬Ìí¼Ó·þÎñÆ÷²»³É¹¦¡£ÕâÓйØÏµÂð£¿
·þÎñÆ÷¿ªÕêÌý·þÎñ£¬¿Í»§¶ËÒ²ÒªÂð
¼
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÒÔÏÂÊÇÒ»¶ÎJavsScript½Å±¾£¬µ«ÔËÐÐʱ×Ü»á²úÉú ¡°Microsoft JScript ÔËÐÐʱ´íÎó: 'null' Ϊ¿Õ»ò²»ÊǶÔÏó¡±Òì³££¬´ó¼Ò°ï¿´Ò»Ï¡£
<form id="form1" runat="server">
< ......