Hi! Trying to use dotConnect with EntityFramework and MySql. My ConnectionString is:
When trying to connect to any table of the database I get an exception:
SELECT command denied to user 'user'@'192.168.0.30' for table 'OrganizationPlans'
While I was using standard connector(MySql.Data.MySqlClient) I had no this issue. Why can this happen?
Thanks in advance.[/img]
SELECT command denied to user ...
Please check if a correct schema (database) name is used in the queries. You can do that with the dbMonitor tool.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/mysql/ ... nitor.html
If the reason is a schema name, there are two solutions:
1) turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/ ... orkarounds
2) remove Schema attributes from your EntitySets in SSDL (with Entity Developer or with XML Editor).
We have removed your duplicate post.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/mysql/ ... nitor.html
If the reason is a schema name, there are two solutions:
1) turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/ ... orkarounds
2) remove Schema attributes from your EntitySets in SSDL (with Entity Developer or with XML Editor).
We have removed your duplicate post.