VS C# .net 3.5 Á¬²»ÉÏoracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²ÁËVS2010ºÍoracle 11g, ¼° Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio

Ïë²åÈëͼƬ£¬µ«ºÃÏñ²»ÐУ¬ÎÒÀ´ÃèÊöÏ£º

°²ºÃÉÏÃæµÄ¶«¶«ºó£¬ÎÒ°ÑÍøÕ¾¼ÓÁËreference: Oracle webºÍOracle Access
ÔÚConfigure Data Source Àïн¨Connection, Data SourceÀïoracle DatabaseÓÐÁ½¸öData provider:
1) .NET Framework Data Provider for OLE DB
2) .NET Framework Data Provider for Oracle
ÕâÁ½¸öÎÒ¶¼ÊÔ¹ý£¬¶¼²»ÄÜÁ¬ÉÏ£¬error info is: 

ORA-12154: TNS:could not resolve the connect identifier specified

ÇëÎÊÊÇʲôԭÒòÄØ£¿

---

ÅäÖúÃtnsnames.oraÏÈ¡£

---

ÒýÓÃ

ÅäÖúÃtnsnames.oraÏÈ¡£

ÎÒÁ¬½ÓÓõÄservice namingÊÇGUESTBOOK,ÔÚtnsnames.oraÀïÊÇÓеģ®Õâ¸öGUESTBOOK,ÎÒÊÇͨ¹ýDBCAÀ´½¨µÄ£®

SQL code:
# tnsnames.ora Network Configuration File: D:\app\v-trajin\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

GUESTBOO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Win2k3-JinLing.fareast.corp.microsoft.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Guestbook)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Win2k3-JinLing.fareast.corp.microsoft.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SE