"problem to connect to Access DB in remote server"

ilaria_goriilaria_gori Member Posts: 15 Maven
edited May 2019 in Help
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

Tagged:

Answers

  • haddockhaddock Member Posts: 849 Maven
    Hi there,
    The URL passed to RmiJdbc is of the form:
      "jdbc:rmi:" + "//" <hostname>[:<port>] + "/" + <full-JDBC-url>
    http://rmijdbc.ow2.org/RJfaq.html

    Perhaps your URL is missing that "//"?

    Good weekend to all!


Sign In or Register to comment.