mysql and .net: when using tableadapters I’m getting MySqlException “insert command denied for user”
- by Deveti Putnik
Hi!
I am using mysql as db for my asp.net application. Here are the facts:
I am using connection string from web.config which has both username and password.
I can do SELECT with tableadapter.
When I am trying to do INSERT with tableadapter, I am getting "mysqlexception insert command denied for user" error
When I try to do INSERT programatically, i.e. using connection, command object, etc. everything is fine. In this case, I'm reading connection string from web.config, too.
This can be only applied to GoDaddy hosting, but on local machine I don't have this kind of problems.
Can anyone suggest what can I do to make it work on GoDaddy hosting?
Regards,
D