Sybase ASE / Entity Framework 6 in Visual Studio 2013

[Former Member]

Hi,

My objective is to connect to Sybase ASE with Entity Framework 6 in Visual Studio 2013.

I try SQL Anywhere 16 without success in VS 2010/2013 .
With Sybase Ase Client it's ok in Visual Studio 2010 but not In VS 2013.

1 - The SQL Anywhere Provider can be used to connect to a Syabse ASE ?

      Used version : iAnywhere.Data.SQLAnywhere Version=16.0.0.20434

2 - After instal Sybase Client, I'm able to use Sybase provider in Visual Studio 2010 but Not In Visual Studio 2013
     Sybase.AdoNet4.AseClient, Version=16.0.0.2

    Sybase.AdoNet4.AseClient is compatible with Visual Studio 2013 ?

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

<system.data>

    <DbProviderFactories>

      <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5"

        description=".NET Framework Data Provider for Microsoft SQL Server Compact"

        type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

      <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0"

        description=".NET Framework Data Provider for Microsoft SQL Server Compact"

        type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

      <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.v4.5, Version=16.0.0.20434, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />

      <add name="Sybase Adaptive Server Enterprise Data Provider" invariant="Sybase.Data.AseClient"

        description=".NET Framework Data Provider for Sybase Adaptive Server Enterprise"

        type="Sybase.Data.AseClient.AseClientFactory, Sybase.AdoNet4.AseClient, Version=16.0.0.2, Culture=neutral, PublicKeyToken=95d94fac46c88e1e" />

    </DbProviderFactories>

  </system.data>

Visual Studio 2010

Visual Studio 2013

Thanks

[Former Member · Accepted solution]

ASE (Adaptive Server Enterprise) and SQL Anywhere (SQL Anywhere Studio) are 2 separate database technologies.

A1) The SQL Anywhere client can't connect to to ASE.

A2) Please ask your question about why the ASE provider only works with VS 2010 and not VS 2013 on the ASE community forum. I've included the link below.

Many thanks

Mark

[jeff_albion]

Hi Yassine,

I try SQL Anywhere 16 without success in VS 2010/2013 .

Have you tried the steps listed in my answer here: Entity Framework 6.* provider - SQLA Forum to get EF6 working with SQL Anywhere? VS2012 / 2013 should be supported after 12.0.1.4162 and 16.0.0.2014. You will need to add the App.config reference in the project yourself.

Regards,

Jeff Albion

SAP Active Global Support

[Former Member]

Hi Jeff,

Yes, i tried the steps listed in http://sqlanywhere-forum.sap.com/questions/22161/entity-framework-6-provider , I see the provider SQL Anywhere 16 in DDEX on VS 2013 and 2010 , but can't connect to Syabse ASE.

As Mark  Tunmer says : "ASE (Adaptive Server Enterprise) and SQL Anywhere (SQL Anywhere Studio) are 2 separate database technologies".

Regards,
Yassine

[former_member195252]

As Mark indicated, the SQL Anywhere client will NOT work with ASE.   You should ask your questions about the ASE client in the ASE forum: SAP Adaptive Server Enterprise (SAP ASE) for Custom Applications