mysql and .net: when using tableadapters I'm getting MySqlException "insert command denied for user", otherwise everything is fine

Question

Hi!

I am using mysql as db for my asp.net application. Here are the facts:

1. I am using connection string from web.config which has both username and password.
2. I can do SELECT with tableadapter.
3. When I am trying to do INSERT with tableadapter, I am getting "mysqlexception insert command denied for user" error
4. 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.
5. 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

Answer 1

I know that's old question, but I want to have all my questions answered. Anyway, when you write sql command that should be executed you must add full table names with database name included.