🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉
Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.
"problem to connect to Access DB in remote server"
from my own laptop I have to read an Access DB which is located on a remote server.
I made the following steps:
on the server:
1. I set the ODBC driver for my DB (as explained in http://rapid-i.com/wiki/index.php?title=Microsoft_Access) ---> "myDB"
2. I downloaded RmiJdbc from http://forge.ow2.org/project/showfiles.php?group_id=8&;release_id=623 and run RJJdbcServer
On the client:
1.I downloaded RmiJdbc
2. in Rapid Miner I created a new driver ("rmijdbc") by pointing to RmiJdbc.jar
3. in Rapid Miner I created a new connection with URL: jdbc:rmi:IPSERVER:1099/jdbc:odbc:myDB
If I test the connection I get the error " [Microsoft][Driver Manager ODBC] nome origine dati non trovato e driver predefinito non specificato" ("name data origin not found and predefined driver not specified").
Moreover I noticed that if myDB exists on my laptop too, it reads that DB!!
please could you help me?
thanks a lot