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!
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 ?
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?
