ASP.NET MVC 连接oracle报错，请问如何解决？

我是本机 WIN7 64bit 10g数据库，VS2010 ,ASP.NET MVC2 用的.netframe 4.
在执行如下的connection.Open(); 报错：
 OracleConnection connection = new OracleConnection();

            connection.ConnectionString = "Data Source=localhost;Persist Security Info=True;user id =gacrj;Password=gacrj";
            DataSet ds = new DataSet();
            try
            {
                connection.Open();
                OracleDataAdapter command = new OracleDataAdapter(SQLString, connection);
                command.Fill(ds, "ds");
            }
            catch (System.Data.OracleClient.OracleException ex)
            {
                throw new Exception(ex.Message);
            }
            return ds;
       
报错如下：
{System.Data.OracleClient.OracleException (0x80131938): ORA-12154: TNS: 无法解析指定的连接标识符

   在 System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   在 System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   在 System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   在 System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   在 System.Data.OracleClient.OracleConnection.Open()
   在 Maticsoft.DBUtility.DbHelperOra.Query(String SQLString) 位置 D:\Work\Source20140924_MQWGR\MqWgrMSys\DAL\DbHelperOra.cs:行号 297}

以为是连接串有问题，用了以下几种都报如上的错误
     //connection.ConnectionString = "Data Source=gacrj27;User ID=gacrj;Password=gacrj";
            //connection.ConnectionString = "user id=gacrj;data source=localhost;password=gacrj";
            //connection.ConnectionString = "Data Source=localhost;Persist Security Info=True;User ID=gacrj;Password=gacrj";
 请问如何解决？多谢了

4 个解决方案

#1

自己顶一下，，，，，

#2

自己顶一下，，，，， 

#3

实例名不对了？

看看这个讨论:

http://*.com/questions/12445201/connecting-c-sharp-app-with-oracle-10g-ora-12154-tnscould-not-resolve-the-con

#4

You can use XE instance name if you've oracle 10g express edition.  来自上面的链接。