EntityFramework.IBM.DB2 can't connect to db2

db2 entity-framework entity-framework-6

Question

I'm trying to connect to a db2 instance using EF6 and the new IBM Entity Framework data provider found here

have added the provider to the app config: 

<providers>
    <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    <provider invariantName="IBM.Data.DB2" type="IBM.Data.DB2.EntityFramework.DB2ProviderServices, IBM.Data.DB2.EntityFramework, Version=10.5.5.6, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
</providers>

and connection string looks like so:

<add name="DB2" connectionString="Server=blah;Database=meh;Uid=user;Pwd=pword;" providerName="IBM.Data.DB2" />

I can instantiate a context but when I try to run a query it throws a MethodAccessException:

Attempt by method 'IBM.Data.DB2.EntityFramework.DB2ProviderServices.GetDbProviderManifestToken(System.Data.Common.DbConnection)' to access method 'IBM.Data.DB2.DB2Trace.Entity_CheckDB2Trace()' failed.

I have installed the DB2 Version 10.5 Fix Pack 5

Any ideas as to what I might be doing wrong?

1
3
1/6/2015 9:07:35 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Turns out I had installed the 10.5.5 driver but it failed to be set as the default. After running the "Default DB2 and Database Client Interface Selection wizard" (found just by searching in the start menu) and setting the new one as the default it worked fine

3
1/7/2015 12:29:03 AM

Popular Answer

@Ramu, I have recently started migrating one of our legacy applications and started figuring out how to connect to IBM DB2 using Entity Framework 6. To answer straight to your question - its not possible to work in VS 2015 as IBM database add-ins are supported only until VS 2013. We have contacted IBM and they have no idea if they are going to release these add-ins for VS 2015.

As a work around I built my repository in VS 2013 and made it as a nuget package. I have imported that package into my VS 2015 project. Now packages are much cleaner way of doing it than giving hard dll references.

This is how I setup the environment

  1. Install IBM DB2 10.5 with Fix-pack 7. That should get IBM Data server Client 10.5.
  2. On the same installation package – Install IBM Database Add-Ins for Visual Studio.
  3. Install IBM Data server Driver 10.5.
  4. Install EF Tools for VS2012/VS2013

Go to programs and features - and always make sure both IBM Data server client and IBM Database add-ins for VS should have same version, release and fix-pack level.

Hope this helps.

Ram

Related Questions

Is Entity Framework compatible with a DB2 iSeries AS/400?

It sort of looks like it is - see here:...http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0054118.html?resultof=%22%65%6e%74%69%74%79%22%20%22%65%6e%74%69%74%69%22%20%22%66%72%61%6d%65%77%6f%72%6b%22%20...but quite honestly, I'm not 100% sure - especially not if it supports EF 4.0 (yet)....Or check...
db2 entity-framework ibm-midrange
asked by marc_s

DB2 queries get occasional SQL0925N: Processing cancelled due to interrupt error

I was able to solve this issue by setting the ...CommandTimeout... on my EF data context like this:...using (dataContext = new myDB2Entities()) { dataContext.CommandTimeout = 60; // DB CODE } ...I understand now that the ...QueryTimeout... setting I had been trying to use is simply a time interval, and at every interval the database check...
.net db2 entity-framework sql
asked by Borophyll

Entity Framework for DB2

Regarding your questions:...The standard data provider for DB2 doesn't support EF6, Code-First, Code-First Migrations. In case, your scenario requires these features, you should use third-party data providers....Yes, you could use the DbContext class with the standard data provider via Database-First approach, i.e. without its Code-First/Code-Firs...
db2 entity-framework
asked by Devart

Can't connect to MySql database with Entity Framework 6

Installed via NuGet: MySql.Data, MySql.Data.Entities, MySql.Data.Entity....Web.config:...<connectionStrings> <add name="WhateverEntities" providerName="MySql.Data.MySqlClient" connectionString="server=127.0.0.1;port=3306;database=dbname;uid=root;password=pass" /> <connectionStrings> .........<entityFramework> <defaultConnectionFactory type="MyS...
connection-string database-connection dbcontext entity-framework-6 mysql
asked by Tomo

Access IBM db2 database with asp net 5

I need to connect my ASP Net 5 application with a IBM Db2 database....I found these nuget package:...https://www.nuget.org/profiles/IBMDB2EF...And i followed this tutorial:...https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/sample_ef7_application_for_ibm_data_servers?lang=en...But that does not work....M...
ado.net-entity-data-model asp.net-core db2-400 entity-framework-6 entity-framework-core
asked by Jonhy.Olivas

Generating an EDMX from a DB2 Database

In order to use Entity Framework and Visual Studio... you need to install IBM's drivers as well as a Visual Studio Add-in (to make DB2 show up in the dropdown of data providers and create an EDMX properly). The following is the setup we use to communicate with DB2 z/os. I am not sure whether or not these same drivers work with DB2 Linux/Unix/Wind...
c# db2 edmx entity-framework-6
asked by Borophyll

Accesses DB2 with entity framework 6 on visual studio 2015

I'm trying to access DB2 V10 over z/OS via visual studio 2015 and entity framework 6....After some research i found some promising article - ...http://www.ibm.com/developerworks/data/library/techarticle/dm-0903linqentity/...However the example used is for 2010 and the same Add-in is not getting installed for 2015. ...Is there any better way of doin...
add-in db2 entity-framework-6 visual-studio-2015
asked by Ramu

IBM DB2 Entityframework issue

Please help if you know how to fix this issue. ...VS 2015 Nuget Package manager Installed - EntityFramework 6.1.3 + IBM DB2 EntityFramework 6.0.6 EDMX file created from database. ...Getting error on...public partial class dbb1Entities : DbContext { public dbb1Entities() : base("name=dbb1Entities"){} } ...Error:...The Entity Framework ...
db2 entity-framework-6 visual-studio-2015
asked by AlpPru

How to setup IBM DB2 9.7 to work with Entity Framework 6 and Visual Studio 2015?

I'm using Visual Studio 2015 to develop an ASP.NET MVC application on a Windows 7, 64-bit machine and I want to connect to an IBM DB2 9.7 database using Entity Framework 6 (Code-First). ...Background...I've found a number of articles online that indicate that the ...IBM Data Server Driver... package and the ...IBM Visual Studio Add-In... are requir...
.net-4.5 asp.net-mvc-5 db2-9.7 entity-framework-6 visual-studio-2015
asked by user2063351

How to get EF6 to work with DB2 in Visual Studio 2017

I've read numerous articles and posts here about getting Entity Framework to work with DB2 but all of them reference prior versions of Visual Studio. When I repeat the steps outlined (too many to remember at this point), I still do not have DB2 in the data providers list....Has anyone gotten this to work in VS17 and, if so, can you walk me through...
db2 entity-framework-6 visual-studio-2017
asked by SonOfPirate

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow