Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"problem to connect to Access DB in remote server"
ilaria_gori
Member Posts: 15 
Maven
Hi all,
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
ilaria
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
ilaria
0
Answers
Perhaps your URL is missing that "//"?
Good weekend to all!