Oracle.DataAccess.Client.OracleException在Connection.Open()Client、DataAccess、Oracle、Open

2023-09-07 16:20:16 作者:笑得那样白痴▲

这个问题可以像其他人的克隆,但我不能找到一个正确的答案,这一个。 这是我的情况: 我有一个调用需要写一个Oracle数据库的WebServices C#软件。 在我的测试服务器没有问题,它的工作原理就像一个魅力,但对另服务器它给我这个错误:

this question can look like a clone of others, but I can't find a correct answer to this one. This is my scenario: I have a C# software called by webservices that need to write to an oracle database. In my test server no problems, it works like a charm, but, in another equal server it gives to me this error:

在Oracle.DataAccess.Client.OracleException   Oracle.DataAccess.Client.OracleException.HandleErrorHelper(的Int32   ERR code,为OracleConnection康涅狄格州,IntPtr的opsErrCtx,OpoSqlValCtx *   pOpoSqlValCtx,对象的src,字符串的过程,布尔B检查,的Int32   isRecoverable)在   Oracle.DataAccess.Client.OracleException.HandleError(的Int32 ERR code,   为OracleConnection康涅狄格州,IntPtr的opsErrCtx,对象SRC)在   Oracle.DataAccess.Client.OracleConnection.Open()

Oracle.DataAccess.Client.OracleException at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open()

在没有其他消息。 我认为这是一个错误安装Oracle客户端,但是,另外一个小应用程序,我写信给测试Oracle连接如下:

With no other messages. I thought that it is an error installing oracle client, but, another small application that I wrote to test oracle connection works:

var connectionString = ConfigurationManager.AppSettings["connectionString"];
using (OracleConnection nwindConn = new OracleConnection(connectionString))
{
   nwindConn.Open();
   Console.WriteLine("opened");
}

ConnectionString的:

ConnectionString:

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=thisdatabase.thisinstance)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serv)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=180)(DELAY=5))));User ID=myuser;Password=mypsw;

所以,这个问题,我觉得是在应用程序的配置,但是为什么其他服务器上的同一作品?的 我尝试编辑项目和解决方案的调试平台配置,但问题依然存在。任何建议?

So, the problem, I think is in the application configuration, but why the same works on other server? I tried to edit Project and Solution debug platform Configuration but the problem still exists.. Any suggestions?

推荐答案

问题与应用程序的IIS用户已经开始,应用程序传递低谷。 我改变了它与我的管理员用户,它就像一个魅力。 谢谢你啦。

the problem was the IIS user with application was started, "Application pass-trough". I changed it with my administrator user and it works like a charm. Thank you anyway.