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

¡¾ÐÂÊÖÇë½Ì¡¿¿Í»§¶ËÁ¬½Ó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ÎÞ·¨Í£¡£

Çë½Ì¸÷λ¸ßÊÖ£¬ÕâÎÊÌâµ½µ×³öÔÚÄÄ£¿
ÄãÒѾ­Í¨¹ý·þÎñÃû¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË,²»ÐèÒªODBCÁË.

ÒýÓÃ
ÄãÒѾ­Í¨¹ý·þÎñÃû¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË,²»ÐèÒªODBCÁË.


ͬÒ⣬ʹÓÃoracle²»ÐèÒªÅäÖÃodbc

LS¶þ룬ÎÒ×îÖÕÄ¿µÄÊÇÔÚc#ÖнøÐÐÊý¾ÝÁ¬½Ó¡£¿ÉÊÇÎÒÁ¬²»ÉÏ¡£

ÒýÓÃ
LS¶þ룬ÎÒ×îÖÕÄ¿µÄÊÇÔÚc#ÖнøÐÐÊý¾ÝÁ¬½Ó¡£¿ÉÊÇÎÒÁ¬²»ÉÏ¡£

C#Ã²ËÆÖ»Òª¿Í»§¶ËÄÜÁ¬£¬Ö±½ÓʹÓÃNETÅäÖõÄÄǸö·þÎñÃû¾Í¿ÉÒÔ°¡¡£±ÈÈç¾ÍÓÃÄãÕâÀïµÄtestÓ¦¸ÃÊÇûÎÊÌâµÄ¡£
¿ÉÄÜÎÊÌ⻹ÊdzöÔÚC#

Ö§³ÖÒ»ÏÂ~

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


Ïà¹ØÎÊ´ð£º

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

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

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

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

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

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

ORACLE ·ÖÒ³ - Java / Web ¿ª·¢

´ó¼ÒÓöµ½ORACLE·ÖÒ³¶¼ÊÇÔõô´¦ÀíµÄ£¿
ÊÇÓÃSQLÓï¾ä·ÖÒ³£¿»¹ÊÇÓÿɹö¶¯µÄ½á¹û¼¯·ÖÒ³£¿
Ï£Íû´ó¼ÒÄܰѴúÂëÌù³öÀ´¡£
×îºó´ó¼Ò¸Ð¾õÄÄÖÖЧÂʸߣ¿ÎªÊ²Ã´£¿
ÒªÊÇÓÃhibernateµÄ»°£¬¾Í²»ÓùÜÊDz»ÊÇoracleÁË¡£
ÎÒÖ»ÖªµÀorac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ