Hi.
I am trying to get OSA to work with Oracle.ManagedDataAccess.Client, is this not supported?
I get the following Error: ORA-01017: invalid username/password; logon denied
Here are some of the variations of connection string, I have been testing with.
- Data Source=BLA.BLA.COM;
- Data Source=BLA.BLA.COM;User Id=/;
- Data Source=BLA.BLA.COM;Integraded Security=SSPI;
- Data Source=BLA.BLA.COM;Trusted Connection=True;
- Data Source=BLA.BLA.COM;User Id=/;Integraded Security=SSPI;
- Data Source=BLA.BLA.COM;User Id=/;Trusted Connection=True;
Integrated Security and Trusted Connection gives me, unknown or illegal connection string attribute errors.
My first assumption would be that my Operating System Account doesn't have access to the Oracle Database I am trying to log on to.
But I am fully capable of connecting to the database with OSA with sqlplus, sqldeveloper and toad.
Can somebody explain to me why this isn't working? And what I may do to fix it?
It may be worth mentioning that I am trying to use the 12c x86 ODP.NET Managed Provider, against 11g/11.2 Oracle Databases.