Skip to Content
avatar image
Former Member

How to configure Entity Framework connection?

I'm trying to make an entity framework to a Sybase database. I have installed SQL Anywhere 16 and the iAnyware.Data.SQLAnywhere.v4.5 NuGet package. I can't seem to find any sample code or instruction on how to configure the data provider and get the error:

: 'Unable to determine the provider name for provider factory of type 'iAnywhere.Data.SQLAnywhere.SAFactory'. Make sure that the ADO.NET provider is installed or registered in the application config.'

when trying to access the database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 22, 2017 at 03:54 AM

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

    In addition,
    The "SQL Anywhere" tag is reserved for Japanese posts.
    "SAP SQL Anywhere" as the primary tag for SQL Anywhere questions in English.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2017 at 05:13 PM

    Thanks, but I looked at that link before asking the question. I am using Visual Studio 2015 and 2017. When I get to the step where I'm supposed to create a new connection, I see only SQL Anywhere ODBC options, NOT the ODBC dsn for my Sybase connection. I can't find any way to get past this step.

    Add comment
    10|10000 characters needed characters exceeded