ODBC Data Source Name (DSN) Check
Ensure you have a working ODBC DSN that successfully connects to your target Database via any of the following, all found in the /Applications/iODBC/ directory:
-
ODBC Administrator Tool – using the ODBC DSN “Test” option
-
C++ Demo or iODBCTest Tools
Know Your JDBC Driver’s Identity
For instance, the OpenLink JDBC-to-ODBC Bridge driver has the Java Class Name:
openlink.jdbc4.Driver
JDBC URL Construction and Troubleshooting
Ensure you’ve created a valid JDBC URL, i.e., one that includes valid connection attribute name and value pairs.
A typical OpenLink JDBC-to-ODBC Bridge URL is of the form:
jdbc:openlink://ODBC/DSN={ODBC-DSN}/UID={username}/PWD={password}/
Example
Given an existing ODBC DSN, “Virtuoso on Demo”, your JDBC-to-ODBC Bridge Driver URL would be as follows:
jdbc:openlink://ODBC/DSN=Virtuoso on Demo/UID=dba/PWD=dba/
At this juncture, if you still cannot establish a basic JDBC-ODBC Bridge Driver connection, please open a support case using our online support system.
Support System Guidelines
Before opening a support case, please collect the following information, using the commands provided.
Host Operating System Version
Command:
sw_vers
Sample Output:
ProductName: Mac OS X
ProductVersion: 10.14.6
BuildVersion: 18G6032
Java Version:
Command:
java -version
Sample Output:
OpenLink Generic Driver for JDBC(TM) 4.2 Version 04.54 (Release 8.0)
Driver JAR:
Command:
java -jar /Library/Java/Extensions/opljdbc4_2.jar
Sample Output:
OpenLink Generic Driver for JDBC(TM) 4.2 Version 04.54 (Release 8.0)
Driver Library:
Command:
strings /Library/Java/Extensions/libopljodbc4_2.jnilib | grep Release
Sample Output:
Release
Version 08.00.191217 as of Tue Feb 11 2020 (Release 8.0, g1176e5eb1)