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
"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')
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
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 tomachine.config
inDbProviderFactories
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')