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.)