Problem retrieving data from MySQL Database using Database Reader node - SOLVED
Hi all,
This is my first post. I have just started to use KNIME to implement some decision tree workflows and I am trying to retrieve data from my database but running into the following error.
ERROR DatabaseReaderConnection SQL Exception reading Object of type "93":
The query returns the full resultset correctly in MySQL workbench. I have downloaded the latest MySQL drivers and imported them into KNIME but it still produces the same error. I'm using Windows 8.1 64-Bit install.
Any help would be welcome.
Simon