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