Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog window?
Steps:
- Right-click on the edmx design surface.
- Select "Update Model from Database"
- On the Update Wizard, click "New Connection"
- 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