Hello...I'm having trouble getting connected to an Oracle 11.2.0.4 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 http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html )
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.