Hi
The Model returns the same error for all my table: SomeTableInModel = 'Some_Model.SomeTableInModel' threw an exception of type 'Telerik.OpenAccess.Exceptions.DataStoreException'
If I try and read some data in the Model I get [Telerik.OpenAccess.Exceptions.DataStoreException] = {"Unable to reach database server on host ''.\nError Details:Unable to connect to any of the specified MySQL hosts.\n"}
I have made sure this is done http://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-mysql-overview
http://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-backend-strings-provider-names-list
Here is the connection strings I use:
* In rlinq file:
<orm:orm name="Some_Model" backend="MySql" xmlns:orm="http://tempuri.org/ORM">
...
<AppConfigConnectionPropertyName>SomeDBConnection</AppConfigConnectionPropertyName>
<AppConfigConnectionString>Data Source=localhost;Initial Catalog=SomeDB;Integrated Security=False;User ID=root;Password=xxx;Connect Timeout=2;User Instance=False</AppConfigConnectionString>
...
<BackendConfigurationSettings>
<BackendConfiguration>
<Backend>MySql</Backend>
<ProviderName>System.Data.MySqlClient</ProviderName>
<Logging>
<MetricStoreSnapshotInterval>0</MetricStoreSnapshotInterval>
</Logging>
</BackendConfiguration>
</BackendConfigurationSettings>
* In my web.config file for the project:
<connectionStrings>
<add name="SomeDBConnection1" connectionString="Data Source=localhost;Initial Catalog=SomeDB;Integrated Security=False;User ID=root;Password=xxx;Connect Timeout=2;User Instance=False" providerName="System.Data.MySqlClient"/>
</connectionStrings>
I'd be grateful for any help.The Model returns the same error for all my table: SomeTableInModel = 'SomeModel.SomeTableInModel' threw an exception of type 'Telerik.OpenAccess.Exceptions.DataStoreException'
If I try and read some data in the Model I get [Telerik.OpenAccess.Exceptions.DataStoreException] = {"Unable to reach database server on host ''.\nError Details:Unable to connect to any of the specified MySQL hosts.\n"}
I have made sure this is done http://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-mysql-overview
http://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-backend-strings-provider-names-list
Here is the connection strings I use:
* In rlinq file:
<orm:orm name="TFDB_Model" backend="MySql" xmlns:orm="http://tempuri.org/ORM">
...
<AppConfigConnectionPropertyName>SomeDBConnection</AppConfigConnectionPropertyName>
<AppConfigConnectionString>Data Source=localhost;Initial Catalog=SomeDB;Integrated Security=False;User ID=root;Password=xxx;Connect Timeout=2;User Instance=False</AppConfigConnectionString>
...
<BackendConfigurationSettings>
<BackendConfiguration>
<Backend>MySql</Backend>
<ProviderName>System.Data.MySqlClient</ProviderName>
<Logging>
<MetricStoreSnapshotInterval>0</MetricStoreSnapshotInterval>
</Logging>
</BackendConfiguration>
</BackendConfigurationSettings>
* In my web.config file for the project:
<connectionStrings>
<add name="SomeDBConnection1" connectionString="Data Source=localhost;Initial Catalog=SomeDB;Integrated Security=False;User ID=root;Password=xxx;Connect Timeout=2;User Instance=False" providerName="System.Data.MySqlClient"/>
</connectionStrings>
I'd be grateful for any help.