Attempting to connect using Oracle.ManagedDataAccess to a vendor database running 12c gets a ORA-01017.
Details:
Vendor database: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Source systems are both windows 7 64bit.
I've tried with Visual Studio 2017 and Visual Studio 2013 (different pc) with same results.
I've updated Oracle Developer Tools for Visual Studio 2017 to 18.3.0 with no change.
MDAC versions tried:
V18.6.0 (NuGet)
V18.3.0 (NuGet)
12.1.21 (NuGet)
4.121.2.0 ODAC release 4 (installed manually, didn't use NuGet)
What does work:
SQL Developer
TOAD
sqlplus
ODBC
including OdbcConnection called in .net console app
Unmanaged Data Access (same exact code just change using at the top to Oracle.DataAccess.Client).
Also using MDAC, I can connect to the systems at my company which are oracle 10.2 and 11g without issue.
Details:
Tried the various connection methods including with or without TNS and even with user/password passed in via OracleCredential parameter.
The password is mixed case, contains a numeric and an special character. I've varied my password to include only underscores or exclaimation point or plus sign without a change of behavior.
I've tried the various ways quote the user id and password.
My FipsAlgorithmPolicy is 0 (off)
Here's one sample:
User Id=MY_ID;Password="Aa12345+6";Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = VENDERHOST)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = MMMM)))