How to get the IBM DB2 provider to work with Entity Framework 4.0

visual-studio db2 entity-framework-4 provider
camainc picture camainc · Apr 27, 2010 · Viewed 10.7k times · Source

Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog window?

Steps:

  1. Right-click on the edmx design surface.
  2. Select "Update Model from Database"
  3. On the Update Wizard, click "New Connection"
  4. Next to the "Data source" textbox, click "Change..."

In the Change Data Source window, I am only seeing the following data sources in the list:

Microsoft SQL Server
Microsoft SQL Server Compact 3.5
Microsoft SQL Server Database File
<other>

When I select "other", I only see two entries in the Data Provider dropdown:

.Net Framework Data Provider for Microsoft SQL Server Compact 3.5
.Net Framework Data Provider for SQL Server

How do I get the DB2 provider(s) to show up here so that I can use them to model my DB2 tables?

I am able to successfully connect to DB2 using the VS2010 Server Explorer. The Connection string for that is:

"Provider=IBMDADB2.DB2COPY1;Data Source=DB2THLOC;Persist Security Info=True;User ID=****;Location=****" (stars for security)

The Provider is listed as: 

.NET Framework Data Provider for OLE DB
Type: DB2
Version: 08.01.0005

Many Thanks In Advance

Answer

kdawg picture kdawg · Apr 29, 2010

What you're describing is enabled by the Visual Studio Add-In package from IBM. Currently, there is no such package for vs2010.

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How do you auto format code in Visual Studio?

I know Visual Studio can auto format to make my methods and loops indented properly, but I cannot find the setting.

Read More
How do I remedy "The breakpoint will not currently be hit. No symbols have been loaded for this document." warning?

A C# desktop application on the express edition worked, but then it didn't work 5 seconds later. I tried the following: Ensure debug configuration, debug flag, and full debug information are set on all assemblies. Delete all bin and obj folders …

Read More