Showing results for 
Search instead for 
Did you mean: 

Can't use ADO.NET Prodiver for SQL Anywhere 16

Former Member
0 Kudos


I read and applied the help related to ASP.NET Server programming in order to connect a project to an SQL Anywhere16 data source.

I tried with Visual Studio 2017 and with Visual Studio 2013.

When i select "Add connection" under "Server Explorer" and change the data source, there is no anywhere connection type in list.

I tried to restart the system, to set the project to only 32bit (x86) or only 64bit (x64), use of previous Anywhere 16 SDK version, use of last Anywhere 17 SDK.
There is no way, the ADO.NET Provider for SQL Anywhere 16 doesn't added to list.
Similarly i can't choose SQL Anywhere in Entity Model from Database.

Can you help me?

0 Kudos

The following documents should help you.

Creating a SQL Anywhere ADO.NET Provider Client Deployment Package

Using SQL Anywhere and the ADO.NET Entity Framework


Former Member
0 Kudos

Thx for attention.

Please, read below.

In this:

Create an Entity Data Model from a SQL Anywhere Database

5. In the Data source list, click SQL Anywhere. Then, click Continue.
Note that if SQL Anywhere does not appear in the Data source list, you will need to verify that the SQL Anywhere integration components are properly installed.

I have no SQL Anywhere in the list.
I checked and redo all steps to install and integrate SQL Anywhere in Windows Server, and I can see the related dll registered in machine.config and available through references into Visual Studio project.
But there is no SQL Anywhere in Entity Data Model Data source.

I already added the needed xml code into Web.config, recompiled and restarted the project:

      <clear />
      <add name="SQL Anywhere 16 Data Provider" invariant="iAnywhere.Data.SQLAnywhere" description=".Net Framework Data Provider for SQL Anywhere 16" type="iAnywhere.Data.SQLAnywhere.SAFactory, iAnywhere.Data.SQLAnywhere.EF6, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    <defaultConnectionFactory type="iAnywhere.Data.SQLAnywhere.SAConnectionFactory, iAnywhere.Data.SQLAnywhere.EF6, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="iAnywhere.Data.SQLAnywhere" type="iAnywhere.Data.SQLAnywhere.SAProviderServices, iAnywhere.Data.SQLAnywhere.EF6, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
Active Participant
0 Kudos

Would it be possible to did you installed NuGet Package Manager?

NuGet Package Manager (for Visual Studio 2010) - see:

Accepted Solutions (0)

Answers (0)