-2147467259/ Operation must use an updateable query.

[Amahoro]

Hello, i have a problem with database connectivity toolkit, when I converted the program I'm developing into an application and when I try to execute an INSERT, UPDATE, DELETE query it is giving out an error saying "Operation must use an updateable query." but the SELECT querry it is working properly.

If any feel he/she can help please do not hesitate. Thank you.

[ashley_gee]

Hi Amahoro,

Can you give some more details about what you are doing when this error occurs? Does this error only occur when you run the executable, but not the program in the development environment?  Any additional info will be helpful!

[mikeporter]

What version of LabVIEW? What DBMS? Is there a reason the you are using the DCT? There are easier methods that are much less complicated, and which give errors that are useful.

One of the issues here is that the type of error you cite comes from the SQL engine in the DBMS. Unfortunately the DCT hides the SQL statements from you so you can't tell what the problem really is. So unless the complete error message repeats back to you the command that generated the error, just start looking for anything incorrect. Wrong number of parameters, parameters out of order, permissions problems, etc.

Mike...

[PatrickLye]

"What version of LabVIEW? What DBMS? Is there a reason the you are using the DCT? There are easier methods that are much less complicated, and which give errors that are useful."

@mike

What other methods do you advise?

[mikeporter]

This is a good place to start. This approach does require you to learn a bit about SQL, but it isn't hard and you can at least troubleshoot problems.

http://www.notatamelion.com/2015/01/05/managing-data-the-easy-way/

This technique also increases your support options because it isn't depending on any special software.

Mike...

[rishavpreet]

Hi, I know the thread is old but there aren't any other threads i found for this specific error.

Though i discovered that this error can be caused by security permissions of database file.

If you are using ms-access database then check its permissions.

Open DB file properties go to security tab Select ALL APPLICATIONS PACKAGES and check allow Full Control box by clicking on edit button.

Regards

Rishav Preet