Search code examples
c#oracle-databaseoracle12cdevart

Devart dotConnect Express for Oracle Connection with service name

I have the version 9.1.131.0.

I want to connect to a Oracle 12 DB with a Service Name. I have the login, pw, server, but it seems i can't add a service name or port to OracleConnectionStringBuilder.

How do i connect to my db with a service name?

I can make it happen with Oracle.ManagedDataAccess but due to performance issues i want to test if the Devart Driver is working better.

kind regards

Solution

  • So this is my conclusion:

    Since I don't want my users to install the Oracle Client or a install package more than 10 MB, the Devart dotConnect Express for Oracle will not work.
    Quote from exception:
    "Express Edition doesn't support Direct mode. Do not use Direct parameter of connection string. Refer to dotConnect for Oracle editions matrix."

    Thanks for the help.

    Kind regards