Connect to Oracle using ODBC/JDBC?

Hello...I'm having trouble getting connected to an Oracle database from the KNIME database nodes. (I had this at a previous job, but someone else helped set it up for me, and no one here knows much about ODBC. Including me!) I've read every forum post here and at Oracle that seemed at all relevant, and have tried a variety of jar files in the Database Driver, as well as every variation I can think of or that any post suggested for the database URL. I can connect fine using other programs (TOAD, SAS). Attaching a screenshot to show the format that I think should work.

I have tried ojdbc 5 and 6 as well as 14 (everyone seemed to say it worked, though it's for Oracle 10). Some posts have mentioned ojdbc.jar, but I can't find this anywhere.

(Drivers downloaded from )

The error message every time says: WARN      Database Connector                 java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

(Unless I put an @ symbol in the database URL; then it says WARN      Database Connector                 java.sql.SQLException: ORA-00911: invalid character.)

I would appreciate any ideas or suggestions! I made sure I updated to the most recent version of KNIME, and I have restarted KNIME each time I changed the preferences. I'm on Windows 7 Enterprise 64 bit.

Hi Annarobe, 

Would something like this work?

Specifically, I have you tried the following?


I am having the same issue - I have used the oracle:jdbc driver, and the login params for jdbc:oracle:thin:@//domain:<port>/service, and still cannot connect. Which one of the jdbc:oracle drivers works with oracle