"problem to connect to Access DB in remote server"

ilaria_gori
ilaria_gori New Altair Community Member
edited November 2024 in Community Q&A
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

Answers

  • haddock
    haddock New Altair Community Member
    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!


Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.