×î½ü·¢ÏÖ¸öÆæ¹ÖÎÊÌ⣬ÓÐЩ³ÌÐò Á¬½ÓOracle ͻȻ²»ºÃʹÁË
Ìáʾ ¡°ORA-12154: TNS: ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û¡±
ÎҵķþÎñÆ÷×°ÔÚ±¾»úÁË£¬ÎÒ¿ªÊ¼»¹ÒÔΪÊÇ Oracle µÄÎÊÌ⣬ºóÀ´ÎÒн¨¸öÏîÄ¿ÓÃͬÑùµÄÁ¬½Ó×Ö·û´®
m_cnOrclL2.ConnectionString = @"Data Source=orcl;User ID=scott;Password=tiger";
m_cnOrclL2.Open();
¾Í¿ÉÒÔ Í¨¹ý
¶øÏÈǰµÄÏîÄ¿¾Í²»¿ÉÒÔ£¬ÕâÊÇÎªÊ²Ã´ÄØ£¬ÓôÃÆ°¡
ÊǺܾÃûÁ¬½Ó¹ýÁË?
Ó¦¸ÃÊDz»¹æ·¶°É,Õâ¸öûÓÐserverÄØ?
XML code:
<add key="PersistenceSql" value="Database=testdb;Server=WANG\SQLEXPRESS;PWD=123;UID=sa;" />
this just webconfig
°ï¶¥Ï¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
2Â¥µÄÅóÓÑ£¬Äã·¢µÄÊÇʲôµÄ£¬SQL SERVERµÄÂð£¬ÎÒµÄÊÇ Oracle
==============================
ÎÒ·¢ÏÖºÃÏñ»¹ÊÇÏîÄ¿ÎÊÌâ
ÎÒÔÚÕâ¸öÏîÄ¿ÓÖÌí¼ÓÁ˸öÏîÄ¿£¬»¹ÊDz»ÐС£
µ«ÊÇÎÒÓÖÖØÐ¶ÀÁ¢½¨¸öеÄÏîÄ¿£¬¾Í¿ÉÒÔ¡£Ææ¹ÖÁË£¬ÄÇÎÒÏÈǰÄǸöÏîĿҲ²»Äܲ»Òª°¡
²»¹ÜʲôÊý¾Ý¿â¶¼ÊÇÕâô¸öÁ¬½Ó°¡
Äã¸ü¸ÄÕâ¸öÊÔÊÔ°É
C# code:
string ConnectionString = "Database=testdb;Server=WANG\\SQLEXPRESS;PWD=123;UID=sa";
ÊÇÁ¬µÄ±¾µØÊý¾Ý¿â£¬»¹ÊDZðµÄ·þÎñÆ÷£¬±ðµÄ·þÎñÆ÷Òª½¨Ò»¸ö¿Í»§¶ËµÄ¡£
Ҫô¿´ÊDz»ÊÇORACLEµÄ·þÎñÆô¶¯ÆðÀ´ÁË£¡
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......