What is the ODBC connection string to an Oracle database knowing the JDBC connection string

The working JDBC connection to a Oracle 18c database is like this:

"jdbc:oracle:thin:@//the.server.name.org:1580/boilerinfo"

 

What is the correct ODBC connection string to connect to the same database? I tried just

"odbc:oracle:thin:@//the.server.name.org:1580/boilerinfo"

 

but this doesn't do the trick. I then had a look at www.connectionstrings.com, but couldn't find the JDBC scheme to start with...

 

Additional info

  • The machine running the connection string is a CentOS Linux machine if that matters.
  • I need the ODBC connection string for a new small program which accesses the database in a similar way as the old Java program that uses the JDBC string. (So it would be great if I can avoid changing external files like /etc/odbc.ini.)

0 answers