Getting Error While connecting to DB, "Execute non query : The connection has been disabled

Hi,

Using update query in “Execute non Query” after creating database source name and using mysql odbc connector 5.3.

Not getting consistent result,out of 10, only works for 3 times it update the record, rest all times shows error as “Execute non query : The connection has been disabled.”

connection strings, looks like this:“Dsn=Apple_new;Driver={MySQL ODBC 5.3 ANSI Driver};uid=p;pwd=325”

Also tried connection timeout but same inconsistency. Same connection string works seamlessly for select query.

No issue with db, when tried from MYSQLworkbench, it works fine.

Kindly advice.

Error looks like this:
An error has occured
Source: Newtonsoft.Json
Message: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 410.
Exception Type: JsonSerializationException
Newtonsoft.Json.JsonSerializationException: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 410.

Hi @Prabhu_Venkatraman,

See if this helps you

Thanks,
Prankur

Hi!

finally able to resolve it…
Update query works when you use stored procedure. Without it wont work.

so created one stored procedure in mysql and called the stored procedure in connection.with parameters and it resolved my issue.