Asp.net - oracle connection

Question

1.00/5 (1 vote)

See more:

When I connect to oracle database from my client using WinApp it works well

but if I use The same code in asp.net it gives me this ERROR

ORA-12638: Credential retrieval failed at

Please any help?

What I have tried:

I Changed - SQLNET.AUTHENTICATION_SERVICES= (NTS) To: - SQLNET.AUTHENTICATION_SERVICES= (NONE) in sqlnet.ora.

but not working

Posted 5-Jan-19 20:23pm

Mohammed Elkholy

Updated 5-Jan-19 21:48pm

Add a Solution

Comments

Wendelius 6-Jan-19 3:06am

Do you use Windows or Oracle authentication?

Mohammed Elkholy 6-Jan-19 3:32am

No I use the database user id and password

AnkushK1 6-Jan-19 3:31am

Can you show how you are making connection to oracle in code?

Mohammed Elkholy 6-Jan-19 3:35am

OracleConnection CN = new OracleConnection("Data Source=pay;User ID=paym;Password=paym;Unicode=True");

OleDbConnection CN = new OleDbConnection("Provider=OraOLEDB.Oracle.1;Password=paym;Persist Security Info=True;User ID=paym;Data Source=pay");

the same problem with the oracleconnection and oledbconnection

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2019-01-05T21:48:00

Few things to check or do:

Check Windows Event Log for further information
For the IIS service, check what account you're using to run the service (in Control Panel). Is that account able to communicate to the database server
Ensure that you have changed the correct SQLNET.ORA, the one that IIS uses if it has a different Oracle client installation
Use SQLNET tracing to find more information, for an example, see http://www.dba-oracle.com/t_sql_net_tracing.htm[^]