The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.


I got an new machine with windows 7 x64. Now EF4 throws this error

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

I tried to reinstall SA11 but the error persists.

What should I do?

asked 29 Mar '10, 14:32

Zote's gravatar image

accept rate: 43%

edited 22 Jan '13, 03:42

Volker%20Barth's gravatar image

Volker Barth

It's working now... What I did? I have edited machine.config from frameworks x43 and x64 and added this: <add description=".Net Framework Data Provider for SQL Anywhere 11" invariant="iAnywhere.Data.SQLAnywhere" name="SQL Anywhere 11 Data Provider" type="iAnywhere.Data.SQLAnywhere.SAFactory, iAnywhere.Data.SQLAnywhere, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400"></add> to DbProviderFactories

(29 Mar '10, 14:51) Zote

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

This error is indicating that the ADO.NET provider is not correctly registered in the machine.config using the invariant string you have specified. Your 'work-around' is the correct answer to resolve this issue (to re-add the provider to machine.config in DbProviderFactories and ensure you are using the correct invariant).

Another option is to install EBF or later and run SetupVSPackage.exe /i to appropriately clean up all of the machine.config entries.

(Note: Only the 'full' SQL Anywhere installer modifies the machine.config upon installation - this does not happen automatically if you build a deployment using the 'Deployment Wizard')

(22 Jan '13, 12:54) Jeff Albion

My comment above is an work-around.

permanent link

answered 29 Mar '10, 14:51

Zote's gravatar image

accept rate: 43%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 29 Mar '10, 14:32

question was seen: 1,127 times

last updated: 22 Jan '13, 12:54