Saturday, February 04, 2012   Click here to search  
Welcome: Register | Login
You Are Here » Forums
 
Orlando DotNetNuke® Users Group (ODUG) Forums
 
 
HomeHomeGeneralGeneralHow To, Tips & ...How To, Tips & ...Add the IBM Provider as a Data Source in Visual Studio 2008Add the IBM Provider as a Data Source in Visual Studio 2008
Previous
 
Next
New Post
10/15/2009 3:41 PM
 
User is offline Bob Santuci
No Ranking


rls-technical-services.com
Joined: 2/28/2008
Posts: 11

Add the IBM Provider as a Data Source in Visual Studio 2008
Article ID: 64016
Posted July 21st, 2009
By:
The IBM i DB2 .NET Provider is substantially more functional in V6R1 System i Access for Windows, compared with the previous versions. One of the improvements makes the provider available for selection in the Visual Studio Data Source configuration dialogs.
For example, prior to the V6R1 version, you could create a data connection from the Visual Studio Server Explorer by right-clicking the Data Connection item and selecting Add Connection, as shown in Figure 1. However, the Choose Data Source dialog (Figure 2) did not list the IBM i .NET Provider. The only alternative was to select the .NET Framework Data Provider for OLE DB and use one of the IBM i OLE DB Providers.
With the new support, you will see the IBM DB2 for i5/OS provider listed, as shown in Figure 3. Once you select the provider, you are presented with additional dialogs in the Data Source configuration to set provider-specific properties.
If you are using Microsoft Visual Studio 2005 and you install IBM System i Access for Windows V6R1 on your PC, all is well. The next time you start Visual Studio, you'll be able to work with the newly listed provider.
However, if you're using Microsoft Visual Studio 2008, you need to do a little bit more work. The issue is, when you install IBM System i Access for Windows V6R1, some registry settings are added on your PC. The registry settings that are added by the V6R1 install program are for VS2005. To get the new provider support for VS2008, you need to download a small file from IBM that installs the registry settings for VS2008.
Working with the IBMDB2_VS2008.zip file
The file that you need to get is available on the IBM i Software Technical Document site. The document number is 526181697, V6R1 System i Access .NET Provider Not Listed in Microsoft Visual Studio 2008. You can access the document at this URL: http://tinyurl.com/meugx7
Once you get to the IBM document, download the IBMDB2_VS2008.zip file. When you unzip it, you'll see the two .reg files, shown in Figure 4. To update the registry settings, simply double-click each of the .reg files. When you double-click a .reg file, the Registry Editor confirmation message shown in Figure 5 is displayed. Click OK to install the registry settings, after which the message shown in Figure 6 is displayed.
The entire process, from downloading the file to installing the settings, takes only a few minutes.
The next time you start VS2008, you can create a new Data Source. You should now see the IBM DB2 for i5/OS provider as one of the available options, as shown in Figure 3.
Figure 1
 
 Page 1 of 1
Previous
 
Next
HomeHomeGeneralGeneralHow To, Tips & ...How To, Tips & ...Add the IBM Provider as a Data Source in Visual Studio 2008Add the IBM Provider as a Data Source in Visual Studio 2008


 
     
 
Forum Policy
 
 

These Forums are dedicated to the discussion of the Orlando DotNetNukeUG Users Group surrounding the kindred usage of DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the UG, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

  
     
Terms Of Use | Privacy Statement
© 2008-2011 Orlando DotNetNuke® Users Group (ODUG) 		DotNetNuke® Powered! v5.6.3.45
DotNetNuke® Powered! v05.01.00		 Skin designed by Will Strohl
Website hosted by Applied Innovations
Orlando DotNetNuke® Users Group
DotNetNuke® is a registered trademark of the DotNetNuke® Corporation