hexagon logo

Access Database export problem

Hello everybody,

This is my first post here. I currently want to integrate the measurement data into our company access database. I have created and registered an MDB database via the database wizard. Also, I inserted the STAT ON command into one of our programs to test out the feature. Sadly when the program reached this command, I received an error message like this:

Error[-1] in [Transaction]
Data type mismatch in criteria
State:22005, Native: -3030, Origin:[Microsoft][ODBC Microsoft Access Driver]


What am I doing wrong?
Is it possible that the reason of this error message is that I use PC-DMIS in Hungarian, where the decimal separator is ","? I think the program should handle this (The CSV export uses "." as decimal separator) and I would rather not experiment with the language settings, because once it jammed my probe file.

Thank you in advance!
Parents
  • Hello,

    Thank You for the advices. Formatting the MDB database fields could not solve my problem, so I switched to English language in PC-DMIS and now everything works perfectly. Now I will have to train my operators, but that is not a big problem. Anyway, I think I have a bug, where can I report it?
Reply
  • Hello,

    Thank You for the advices. Formatting the MDB database fields could not solve my problem, so I switched to English language in PC-DMIS and now everything works perfectly. Now I will have to train my operators, but that is not a big problem. Anyway, I think I have a bug, where can I report it?
Children
No Data