net error when using data.oracleclient

Premise:

Except for the leaders and developers who have administrator rights, other personnel in the company use domain accounts.

Process:

Develop a winfrom project as required, use data.oracleclient to develop locally, debug correctly, put it into the server shared domain for user use, and report an error OCIEnvCreate failed, the return code is -1,

I am puzzled by the solution. There are many such mistakes on the Internet. I have tried them one by one and there is no problem with the ending. However, if the domain user has administrator rights, the program can be used normally.

Later, I heard someone suggest that the Oracle server was not in the domain, so I added the development server to the domain. As a result, pl/sql could not connect to the Oracle server, and there was no solution.

Later I heard about data. Oracleclient is used with administrator privileges. I was wondering if it was because of this problem, so I tried to use other dlls.

I first used the old-fashioned oralce.DataAccess and debugged it locally. Then I ran it on the server. As a result, the oralce.DataAccess version conflicted. No solution. Then gave up.

Then tried Oracle.ManagedDataAccess. It works locally and on the server, so happy.

Result:

This OCIEnvCreate failed, the return code is -1. I have been tortured for several days, and I have never been able to find a solution before. In order to catch up with the progress, I set up a webapi, which increased the workload. And the maintenance is not good,

but we can't give up the solution to the problem. Today we follow people's wishes. Although we don't know the specific reason, we finally solved the problem.

The above is the detailed content of net error when using data.oracleclient. For more information, please follow other related articles on the PHP Chinese website!