Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 2,635 times
last updated: 22 Jan '13, 12:54
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.configusing the invariant string you have specified. Your 'work-around' is the correct answer to resolve this issue (to re-add the provider tomachine.configinDbProviderFactoriesand ensure you are using the correct invariant).Another option is to install EBF 11.0.1.2629 or later and run
SetupVSPackage.exe /ito 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')