🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"problem to connect to Access DB in remote server"

User: "ilaria_gori"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with