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.
User contributions licensed under CC BY-SA 3.0