Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect with ODP.NET Core to Oracle 9i database - Managed Driver

Tags:

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?

like image 696
gopek Avatar asked Dec 21 '18 19:12

gopek


People also ask

Does ODP net core require Oracle client?

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.

What is ODP managed driver?

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, .

What is ODP net core?

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.

How do I find my Oracle connection string?

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.


1 Answers

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

like image 191
Wernfried Domscheit Avatar answered Jan 04 '23 17:01

Wernfried Domscheit