mysql and .net: when using tableadapters I’m getting MySqlException “insert command denied for user”

Posted by Deveti Putnik on Stack Overflow See other posts from Stack Overflow or by Deveti Putnik
Published on 2010-03-16T15:15:26Z Indexed on 2010/03/16 15:21 UTC
Read the original article Hit count: 249

Filed under:
|
|
|
|

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

© Stack Overflow or respective owner

Related posts about mysql

Related posts about c#