Visual Studio 2005  Connection to DB2 on IBM i5

Posted on 2008-11-18
Medium Priority
Last Modified: 2013-11-27
I'm a windows programmer tryng to establish a data connection to a DB2 instance on an IBM i5 series machine.  I talked to the IBM support center, and followed the guidelines by installing the required iSeries ODBC drive and accompanying Visual Stuido 2005 Add-Ins as detailed in the following reference doc:


But - when I try to establish a connection using the server IP address and database name - I keep getting the following connection error message:  

Error opening connectionERROR [08001] [IBM] SQL30081N  A communication error has been detected.  Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected: "".  Communication function detecting the error: "connect".  Protocol specific error code(s): "10061", "*", "*".  SQLSTATE=08001

According to my IT guys, there is no firewall blocking and all ports should be open to receive.  How can I check the actual connection is working/listenting on TCP/IP as well as on sockets?  From the error - it seems as though the DB2 instance on the i5 series is not listening on TCP/IP and needs to be.  Any ideas on how I can get this connection to work?  

thanks in advance for any help with this.
Question by:coecho
LVL 37

Expert Comment

ID: 22985692
i guess you need to look on the i5 and run the equivalent command of netstats -an
to see which ports are being listened to

Author Comment

ID: 22987235
I don't know the i5.  What is the equivalent of netstats on the i5 and how would you run it?  

Author Comment

ID: 22988627
It looks like it is listening on port 446.  Now when I try to connect - I'm getting the following error message:

ERROR [42968] [IBM] SQL8002N An attempt to connet to a host failed due to a missing DB2 Connect product or invalid license SQLSTATE=4296B
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments


Accepted Solution

ScottParker earned 1500 total points
ID: 22988853
That error message says its a License issue.
perhaps you do not have a SQL license on your iSeries.


Author Comment

ID: 22989620
Does DB2 Connect need to be installed on the i5 - even if I want to connect via the i5 ODBC iSeries ODBC driver instead?  When I talked with IBM support, they recommded iSeries driver over DB2 Connect.  So - I guess I don't understand if I'm using the correct driver in order to connect via VS 2005 and DB2?  I'm using the "IBM DB2, IDS and U2 Data Provider for the .Net Framework as my Data Source, as detailed in the document IBM support sent me - but now this doesn't seem like the correct Data Source to use and I don't see an option for the iSeries Access ODBC Driver in the Data Source option list from Visual Studio 2005.

Expert Comment

ID: 23942199
This one really hasn't been closed, has it? coecho, did you get it working?

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question