When i try to connect to Oracle 9i db, i get always ORA-1017 invalid username/password; logon denied. On Oracle 10g or higher all is well.
ODP.NET Core: 2.18.3; ASP.NET Core: 2.1.403
ConnectionString: "Data Source=myTnsName;password=myPassword;user id=myUserId"
TnsAdmin is set.
In Oracle log on db side i found this entry: ORA-1017 invalid username/password; Unknown Auth type: 6A
Any ideas are welcome? It is possible to connect?
Managed ODP.NET does not require any Oracle Client installation. The final step is to configure the database server connection, which is specific to your application environment. A sample Oracle connect descriptor and connection string have been created.
ODP.NET, Managed Driver is 100% managed code . NET Framework provider. Developers deploy a single assembly in a deployment package smaller than 10 MB. ODP.NET, Unmanaged Driver is the traditional Oracle ADO.NET provider that uses the Oracle Database Client. ODP.NET 21c add support for user-defined types, .
ODP.NET Core is an ADO.NET driver that provides fast data access from Microsoft . NET Core clients to Oracle databases. It runs on both Windows and Linux. ODP.NET consists of a single 100% managed code dynamic-link library, Oracle. ManagedDataAccess.
Go to C:\Program Files (x86)\Bentley\Plant V8i\Bin\ProjectChecker and open readme. txt file, in which you will find detail information and instruction how to use ProjectChecker. Run ProjectChecker.exe to test existing Oracle user's connection string.
It's not possible, Oracle database below 10.2 is not supported. See Data Provider for .NET Developer's Guide:
System Requirements
Oracle Data Provider for .NET, Managed Driver requires the following:
Same Windows operating system support as ODP.NET, Unmanaged Driver.
ODP.NET, Managed Driver is built with AnyCPU. It runs on either 32-bit or 64-bit (x64) Windows and on either 32-bit or 64-bit (x64) .NET Framework.
Microsoft .NET Framework 4, 4.5, 4.5.1, or 4.5.2
Access to Oracle Database 10g Release 2 or later
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With