Hi,

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;
try
{ String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbUrl = "jdbcdbc:RMI";
String dbUser = "";
String dbPass = "";
Class.forName(dbDriver).newInstance();
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);
}

rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}

}

}