I have used the UCANACCESS driver/ successfully to write data into an Access database on a Windows 7 System using the KNIME Analitcs Platform. Which is a Eclipse-Based Toolkit for DataMining.
I now moved on to a Windows Server 2012 r2 System. I installed the latest (Version 3.0.7) as well as the formally working Version (Version 3.0.4) of UCANACCESS to the path (*/KNIME/jre/lib/ext).
When registering the driver in the KNIME Preference tab the .jar-file is only accepted at a second try. In the Database Connector node the driver did not show up.
Hi,
I have used the UCANACCESS driver/ successfully to write data into an Access database on a Windows 7 System using the KNIME Analitcs Platform. Which is a Eclipse-Based Toolkit for DataMining.
I now moved on to a Windows Server 2012 r2 System. I installed the latest (Version 3.0.7) as well as the formally working Version (Version 3.0.4) of UCANACCESS to the path (*/KNIME/jre/lib/ext).
When registering the driver in the KNIME Preference tab the .jar-file is only accepted at a second try. In the Database Connector node the driver did not show up.
When trying the same thing with the JDBC-Driver for MS SQL-Datebases( https://msdn.microsoft.com/de-de/library/mt683464%28v=sql.110%29.aspx ) it works quite well and the driver shows up.
Has anyone an idea where to locate the problem ?
Regards
FEbe