Connecting to Navision

[Tejo Kumar]

Hi,

How can we connect to Navision using jdbc? Here is the code snippet.

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc :-o	 dbc:sampleDSN","super","");
}catch(Exception e){
System.out.println("Unable to connect to database");
e.printStackTrace();
}
//I am getting the exception at this line
Statement st=con.createStatement();

Exception is:
java.sql.SQLException: The result set type is not supported.

Can anyone solve this problem?

Thanks & Regards,
Tejo Kumar.

[Jeanne Boyarsky]

Tejo,
What driver are you using?

[Tejo Kumar]

Hi,

I have used C/ODBC driver. But I found that it is only for Microsoft Technologies. Now I am trying to connect to Navision using CFRONT.DLL. I donno how to use the functions in that DLL. Can anyone help me in this case.

Thanks in advance,
Tejo Kumar.