How to connect oracle DB using JDBC URL or connection String in Perl script

Question

I have a jdbc connection string and want to connect db in perl script, but no idea how to do it.

my $connstr = 'jdbc:oracle:thin:@ldap://server:port/db_name,cn=OracleContext,dc=world';
my $user = "***";
my $pass = "###";

my $dbh = DBI->connect("dbi:ODBC:$connstr", $user, $pass)

Getting below error::

 DBI connect('jdbc:oracle:thin:@ldap://server:port/db_name,cn=OracleContext,dc=world',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) 

Answer 1

In perl you don't put the OID in the connection string, perl uses standard sqlnet.ora, ldap.ora and tnsnames.ora file. Simply try

DBI->connect("dbi:Oracle:db_name", $user, $pass);

Ensure that your TNS_ADMIN environment variable is properly set.