problems with ODBC

ejml
ejml Member Posts: 3
edited 2002-11-17 in Navision Financials
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?.

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Please check if the Read-only checkmark is cleared in the ODBC Datasource.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • ejml
    ejml Member Posts: 3
    yes, the Read-only checkmark is cleared in the ODBC Datasource.
  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    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.

Categories