https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398614#M8998 According to this Sun forum message (), you can try to connect after closing the Navision application. <BR />Whatever, while searching on this subject through the web, it seems to have problems in the JDBC/ODBC bridge using this driver. <BR />Is there a more recent version of this odbc driver available with Microsoft ? Tue, 21 Aug 2007 09:55:38 GMT smallet 2007-08-21T09:55:38Z https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398613#M8997 hello, <BR />I'm trying to connect TOS to a native Navision 3.60 database, using the ODBC driver, and have the following error message when I check the Db connection : Java.sql.sqlException : column not found. Then TOS crash few seconds after. <BR />I think that the problem is due to the strange Navision field naming convention (in fact there's no convention ,it's allowed to use dots, spaces or any special characters!) <BR />There is an option in the driver to convert the identifiers, I tried every option without success. <BR />Note that it works with the same odbc driver and some other third party programms that I made (Windev,Php). <BR />If anyone has an idea... <BR />Thanks! Sat, 16 Nov 2024 14:34:25 GMT https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398613#M8997 Anonymous 2024-11-16T14:34:25Z https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398614#M8998 According to this Sun forum message (), you can try to connect after closing the Navision application. <BR />Whatever, while searching on this subject through the web, it seems to have problems in the JDBC/ODBC bridge using this driver. <BR />Is there a more recent version of this odbc driver available with Microsoft ? Tue, 21 Aug 2007 09:55:38 GMT https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398614#M8998 smallet 2007-08-21T09:55:38Z https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398615#M8999 The problem comes from the code generated by Talend: <BR /> if (rs_tDBInput_1.getObject(1) != null) { <BR /> row1.DRUG_SCHEME_CODE = rs_tDBInput_1.getString(1); <BR /> } else { <BR /> } <BR />The resultSet of odbc-jdbc bridge allow read once only. <BR />However, the code generator check null by rs_tDBInput_1.getObject(1) !=null <BR />and then place the value to row1 variable by reading the same data rs_tDBInput_1.getString(1) . Most likely, you will get java.sql.SQLException: No data found. <BR />How can I resolve problem like this? Wed, 12 Sep 2007 08:23:58 GMT https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398615#M8999 _AnonymousUser 2007-09-12T08:23:58Z https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398616#M9000 Has a solution been provided for this issue? Fri, 20 Mar 2009 21:10:33 GMT https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398616#M9000 Anonymous 2009-03-20T21:10:33Z https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398617#M9001 Anyone with a further experience regarding this subject? Sun, 27 Jun 2010 18:53:51 GMT https://community.qlik.com/t5/Installing-and-Upgrading/TOS-and-Navision-3-60-native-database-using-C-ODBC-driver/m-p/2398617#M9001 Anonymous 2010-06-27T18:53:51Z