CODEWITHSUNDEEP
c#oracle-databaseoracle9ioracle.manageddataaccess
glautrou
glautrou

Reputation: 3198

Oracle 9i: ORA-01017: invalid username/password; logon denied

I get the following exception when I try to connect to my Oracle 9i database from my Visual Studio 2017 application:

ORA-01017: invalid username/password; logon denied

Code:

var connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myServerName)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=mySID)));User Id = myUsername; Password = myPassword";
var con = new OracleConnection(connectionString);
con.Open();

Same problem when :

I tried setting System\CurrentControlSet\Control\Lsa\FIPSAlgorithmPolicy\Enabled to 0 with no luck.

When I use SQL Developer I am able to connect to the same database with same credentials and perform any query. Any idea ?

Database: Oracle 9i

Visual Studio : 2017

Upvotes: 0

Views: 2849

Answers (1)

glautrou
glautrou

Reputation: 3198

I found the answer.

  • remove any associated plugin in Visual Studio
  • execute uninstall.bat from your ODAC downloaded folder
  • remove any associated tool in Windows Add or Remove Program
  • Remove remaining Oracle folders (in C:\, C:\ProgramFiles, ...)

Make sure there is no remaining Oracle reference in GAC, otherwise delete them.

The latest compatible version of Oracle provider is Oracle version + 2 (9+2=11), meaning the maximum version I had to install was 11.2.0.4. After installing this version and compile my code in x64 (Any CPU or x32 won't load the DLL) evrything was working.

Upvotes: 0

Related Questions