The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.


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,518 times

last updated: 22 Jan '13, 12:54