I am trying to make a workflow with Knime Desktop that reads in a SDF file containing molecular properties of certain molecules, finally when i am trying to write those properties into a table into a database using Database writer node i am getting the following error every time:
ERROR Database Writer Execute failed: java.sql.SQLException:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
I am not sure but from my end i have checked the ODBC Drivers in my machine which are perfectly installed and the data source path. Can you please help me on this or suggest me where should i strike on to correct this.
I am using Oracle 11g and Oracle SQL Developer at my end.