Hello...
I am attempting to generate an ER project for MySQL using the newest Devart package (I had trial, now I have purchased Professional version).
The problem that I am having is that on the 'Relational Model Data Retrieval Wizard' dialog page, I am getting an error when I hit 'test' because I don't have access to the mysql system database, just the individual database. Because I can't specify the database on the connection dialog, I am at a dead end...
Access denied for user 'services'@'%' to database 'mysql'
LLBLGen Pro version 3.1. Build February 7th, 2011
-----[Core exception]--------------------
at Devart.Data.MySql.bk.t()
at Devart.Data.MySql.u.a(String A_0, String A_1, String A_2, String A_3, Int32 A_4, String A_5, Int32 A_6, SshOptions A_7, SslOptions A_8, ProxyOptions A_9, MySqlHttpOptions A_10, HttpOptions A_11)
at Devart.Data.MySql.MySqlInternalConnection.Connect(MySqlConnection owner, String userId, String password, String host, String database, Int32 port, Int32 connectionTimeout, MySqlProtocol protocol, Boolean compress, Boolean clientInteractive)
at Devart.Data.MySql.MySqlInternalConnection..ctor(o connectionOptions, MySqlConnection owner)
at Devart.Data.MySql.ar.a(u A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, u A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.MySql.MySqlConnection.Open()
at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData()
This is a server that I don't have admin access too so I can only connect with my specific database user... how can I get past the 'test'??
thank you... I apologize if this is answered somewhere, I looked in the manual and perused the forums and didn't see anything about this problem.
thank you
ja