The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Hi,

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

Zote
1.7k364050
accept rate: 43%

edited 22 Jan '13, 03:42

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646

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=11.0.1.23622, Culture=neutral, PublicKeyToken=f222fc4333e0d400"></add> to DbProviderFactories

(29 Mar '10, 14:51) Zote
2

"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 11.0.1.2629 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

Zote
1.7k364050
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×137
×65
×18
×1
×1

question asked: 29 Mar '10, 14:32

question was seen: 1,141 times

last updated: 22 Jan '13, 12:54