0

I'm using Dapper and getting this error while trying to connect to Oracle Database

                return new OracleConnection(_configuration.GetConnectionString("CONNECTIONNAME"));

My ConnectionString looks like this:

"ConnectionStrings": {
    "CONNECTIONNAME": "User Id=***;
     Password=***;
     Data Source=MYDB;
     connection timeout=6000;
     licensekey=***"
  },

Does anyone have some idea how to fix it? Thanks

pifor
  • 7,419
  • 2
  • 8
  • 16
  • 2
    As DBA I have never seen that you can give a license key as argument for an Oracle database connection and there is a good reason for this: Oracle Database licenses are not stored in database or file systems (very different from license keys in Windows). I suggest to try to remove this parameter. – pifor Jun 24 '20 at 17:27
  • 1
    Check this [link](https://www.devart.com/dotconnect/oracle/docs/LicensingStandard.html) and more troubleshooting about licensekey is [invalid](https://www.devart.com/dotconnect/oracle/docs/Licensing.html) –  Jun 24 '20 at 22:06

2 Answers2

1

Please take a look at the Oracle Docs for list of valid Connection String Attributes. licensekey is not one of them.

VIX
  • 61
  • 1
  • 5
0

If the issue persists, contact us via https://www.devart.com/company/contactform.html and specify:

  1. The full stack trace of the exception.
  2. Are you working with .NET Framework (C:\Program Files (x86)\Devart\dotConnect\Oracle) and .NET Standard (https://www.nuget.org/packages/devart.data.oracle) Devart.* assemblies?
Devart
  • 119,203
  • 23
  • 166
  • 186