I try to connect to a Navision database through Java program, so I have to use JDBC/ODBC bridge method. First of all I set up a ODBC DSN called RMI in data source. It has no problem because I can access database through MS Access. But when I use a small test program to do connection to the database, I received the error, [Navision a/s][Navision Attain ODBC Driver]ISAM error. Can any one help me to solve this problem. Do I use the right driver?

I attach my small program in case you need.

import java.sql.*;
import java.util.*;

public class TestDB1 {
public TestDB1() {

public static void main (String arg[])
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
{ String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbUrl = "jdbcdbc:RMI";
String dbUser = "";
String dbPass = "";
conn = DriverManager.getConnection(dbUrl, dbUser, dbPass);

String sSQL = "Select * from item ";
stmt = conn.createStatement();
// execute the database query
rs = stmt.executeQuery(sSQL);

while (rs.next())
String commentDesc = rs.getString("description");
System.out.println("CommentDesc is "+commentDesc);

catch(Exception e)