The specified store provider cannot be found in the configuration, or is not valid.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Jayel
Posts: 8
Joined: Wed 27 Dec 2006 17:15

The specified store provider cannot be found in the configuration, or is not valid.

Post by Jayel » Thu 09 Aug 2012 11:02

Hello,

I am using the mysql entity.
But I always get this error on the production machine.
The specified store provider cannot be found in the configuration, or is not valid.

It is a WPF application made with Visual Studio 2010.

greets,

John

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: The specified store provider cannot be found in the configuration, or is not valid.

Post by Shalex » Fri 10 Aug 2012 11:55

Have you registered dotConnect for MySQL's configuration information in the DbProviderFactories section of the *.config file as it is described at http://www.devart.com/dotconnect/mysql/ ... yment.html ?

Jayel
Posts: 8
Joined: Wed 27 Dec 2006 17:15

Re: The specified store provider cannot be found in the configuration, or is not valid.

Post by Jayel » Fri 10 Aug 2012 12:01

Hello,

It is an WPF application.
I don't have an DbFactory setting.
Only connectionstring setting.

greets,

John

Jayel
Posts: 8
Joined: Wed 27 Dec 2006 17:15

Re: The specified store provider cannot be found in the configuration, or is not valid.

Post by Jayel » Fri 10 Aug 2012 12:51

Hello,

I have done everything that is on http://www.devart.com/dotconnect/mysql/ ... yment.html.
I put Devart.Data.dll, Devart.Data.MySql.dll and Devart.Data.MySql.Entity.dll on the same location of my exe file.
Rebuild with the proper license information.

But no go !

On my developer machine everything goes fine!
What I'm a doing wrong?

Greets,

John

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: The specified store provider cannot be found in the configuration, or is not valid.

Post by Shalex » Mon 13 Aug 2012 14:10

Jayel wrote:I don't have an DbFactory setting.
Please add the DbProviderFactories entry for dotConnect for MySQL as it is described at http://www.devart.com/dotconnect/mysql/ ... yment.html.

Jayel
Posts: 8
Joined: Wed 27 Dec 2006 17:15

SOLVED Re: The specified store provider cannot be found in the configuration, or is not valid.

Post by Jayel » Tue 14 Aug 2012 09:02

Shalex,

Thanks,

I thought this was just for webapps.
But when I added the :

Code: Select all

<system.data>
  <DbProviderFactories>
    <remove invariant="Devart.Data.MySql" />
    <add name="dotConnect for MySQL" invariant="Devart.Data.MySql" description="Devart dotConnect for MySQL" type="Devart.Data.MySql.MySqlProviderFactory, Devart.Data.MySql, Version=7.0.6.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
  </DbProviderFactories>
</system.data>
Everything works.
Many thanks !

greets,

John

Post Reply