步骤:
在更改数据源窗口中,我只看到列表中的以下数据源:
Microsoft SQL Server Microsoft SQL Server Compact 3.5 Microsoft SQL Server数据库文件< other>当我选择其他时,我只在Data Provider下拉列表中看到两个条目:
用于Microsoft SQL Server Compact 3.5的.NET Framework数据提供程序 SQL Server的数据提供程序如何让DB2提供程序显示在这里,以便我可以使用它们来建模DB2表? / p>
我可以使用VS2010 Server Explorer成功连接到DB2。连接字符串为:
Provider = IBMDADB2.DB2COPY1;数据源= DB2THLOC; Persist Security Info = True;用户ID = ****;位置= ****(为安全起见)被列为:
OLE DB的.NET Framework数据提供者类型:DB2 版本:08.01 $ 5000非常感谢提前
解决方案您正在描述的内容是由IBM的Visual Studio加载项包启用的。目前,vs2010没有这样的包。
Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog window?
Steps:
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 ServerHow 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.0005Many Thanks In Advance
解决方案What you're describing is enabled by the Visual Studio Add-In package from IBM. Currently, there is no such package for vs2010.
更多推荐
如何使IBM DB2提供程序与Entity Framework 4.0一起工作
发布评论