One Star

TOS and Navision 3.60 native database using C/ODBC driver

hello,
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.
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!)
There is an option in the driver to convert the identifiers, I tried every option without success.
Note that it works with the same odbc driver and some other third party programms that I made (Windev,Php).
If anyone has an idea...
Thanks!
4 REPLIES
Employee

Re: TOS and Navision 3.60 native database using C/ODBC driver

According to this Sun forum message (), you can try to connect after closing the Navision application.
Whatever, while searching on this subject through the web, it seems to have problems in the JDBC/ODBC bridge using this driver.
Is there a more recent version of this odbc driver available with Microsoft ?
One Star

Re: TOS and Navision 3.60 native database using C/ODBC driver

The problem comes from the code generated by Talend:
if (rs_tDBInput_1.getObject(1) != null) {
row1.DRUG_SCHEME_CODE = rs_tDBInput_1.getString(1);
} else {
}
The resultSet of odbc-jdbc bridge allow read once only.
However, the code generator check null by rs_tDBInput_1.getObject(1) !=null
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.
How can I resolve problem like this?
One Star

Re: TOS and Navision 3.60 native database using C/ODBC driver

Has a solution been provided for this issue?
One Star

Re: TOS and Navision 3.60 native database using C/ODBC driver

Anyone with a further experience regarding this subject?