Skip to Content
0

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

Nov 01, 2017 at 07:03 PM

149

avatar image
Former Member

Hi,

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?

10 |10000 characters needed characters left characters exceeded

The following documents should help you.

Creating a SQL Anywhere ADO.NET Provider Client Deployment Package
https://wiki.scn.sap.com/wiki/display/SQLANY/Creating+a+SQL+Anywhere+ADO.NET+Provider+Client+Deployment+Package

Using SQL Anywhere and the ADO.NET Entity Framework
https://wiki.scn.sap.com/wiki/display/SQLANY/Using+SQL+Anywhere+and+the+ADO.NET+Entity+Framework

Thanks,
Atsushi

0
Former Member

Thx for attention.

Please, read below.

In this:

https://wiki.scn.sap.com/wiki/display/SQLANY/Using+SQL+Anywhere+and+the+ADO.NET+Entity+Framework

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:

<system.data>
    <DbProviderFactories>
      <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=16.0.0.25464, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="iAnywhere.Data.SQLAnywhere.SAConnectionFactory, iAnywhere.Data.SQLAnywhere.EF6, Version=16.0.0.25464, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    <providers>
      <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=16.0.0.25464, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    </providers>
  </entityFramework>
0

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

https://wiki.scn.sap.com/wiki/display/SQLANY/Using+SQL+Anywhere+and+the+ADO.NET+Entity+Framework

Requirements
...
NuGet Package Manager (for Visual Studio 2010) - see: https://docs.nuget.org/consume/installing-nuget


0
* Please Login or Register to Answer, Follow or Comment.

0 Answers