| View previous topic :: View next topic |
| Author |
Message |
pleb
Joined: 23 Jun 2008 Posts: 37 Location: Melbourne, Australia
|
Posted: Tue 04 Nov 2008 01:00 Post subject: Entity Framework Deployment Problem -Unable to find provider |
|
|
Hi There,
I've built a little feed down loader which parses and saves the data in a database using the Entity Framework and MySQL provider.
I have some command lines args which force the creation and deletion of the database. These use raw ado.net and the MySQL driver. They work fine.
When I go to import the feed data I get this message
| Quote: | | "The specified store provider cannot be found in the configuration, or is not valid." |
However, when I run the command line program on my development box it works fine.
Initially I thought it'd be a dll missing from the deployment but CoreLab.Data and CoreLab.MySql are there.
Does anyone have any ideas, that I could try?
Pleb |
|
| Back to top |
|
 |
AndreyR Devart Team
Joined: 07 Jul 2008 Posts: 2153
|
Posted: Tue 04 Nov 2008 11:04 Post subject: |
|
|
You should add to the <DbProviderFactories/> machine.config section the following lines:
| Code: | | <add name="MyDirect .NET" invariant="CoreLab.MySql" description="CoreLab MyDirect .NET" type="CoreLab.MySql.MySqlDirectFactory, CoreLab.MySql, Version=4.85.36.0, Culture=neutral, PublicKeyToken=09af7300eec23701" /> |
Also check that the assembly CoreLab.MySql.Entity is available for your application. |
|
| Back to top |
|
 |
pleb
Joined: 23 Jun 2008 Posts: 37 Location: Melbourne, Australia
|
Posted: Wed 05 Nov 2008 00:42 Post subject: |
|
|
Thank you for the hints.
I added the following to the app.config file (Machine config is a little to low level for one application)
| Code: |
<system.data>
<DbProviderFactories>
<add name="MyDirect .NET" invariant="CoreLab.MySql" description="CoreLab MyDirect .NET" type="CoreLab.MySql.MySqlDirectFactory, CoreLab.MySql, Version=4.85.36.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</DbProviderFactories>
</system.data>
|
and included the CoreLab.MySql.Entity assembly in the deployment. |
|
| Back to top |
|
 |
|