problems with ODBC

ejml

Hello everybody. I have a problem when I'm using ODBC of Navision. When I try to make an update on a field of a table through the ODBC, with visual basic code, the following error appears: "ODBC --update on to linked table 'test' failed". Somebody has any idea that fixes it?.

Luc_VanDyck

Please check if the Read-only checkmark is cleared in the ODBC Datasource.

ejml

yes, the Read-only checkmark is cleared in the ODBC Datasource.

Christian_Buehl

I'm not sure If this works on your problem, but try to set the field "identifier" in the options of the odbc-driver.
With setting "a-z,A-Z,0.9,_" (instead of "all except Dot") I solved many problems with ODBC .
You have to do this on every client using ODBC.