C# connection to oracle db using jdbc url

1

I am trying to test a connection on a oracle db using a C# console application with a provided jdbc url from our dba. I have this basic code written.

using System;
using Oracle.DataAccess.Client;

namespace TestDBConnection
{
    class Program
    {
        static void Main(string[] args)
        {
        string conn = "User Id=myuserid;Password=mypassword;Data source=(CONNECT_DATA=(CUSTOM_JDBC_URL=jdbc:oracle:thin:@ldaps://mypath:636/emomod1_app,cn=oraclecontext,dc=safeway,dc=com))";
        OracleConnection myConnection = new OracleConnection();
        myConnection.ConnectionString = conn;
        Console.WriteLine("Starting Connection to Oracle Atlas DB");
        try
        {
            myConnection.Open();
            Console.WriteLine("Connection to Oracle DB Successful!");
        }
        catch(Exception ex)
        {
            Console.WriteLine("Connection to Oracle DB Failed");
            Console.WriteLine(ex.ToString());
        }
    }
}

}

But its failing with error

Oracle.DataAccess.Client.OracleException (0x80004005): ORA-12533: TNS:illegal ADDRESS parameters

What/How is the correct way of using jdbc url as a db connection string? Thanks.

c#
.net
asked on Stack Overflow Aug 20, 2018 by Dren

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0