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:



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



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