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.