.NET referecnes (IBM)


Hello,

I need to make an application talk to AS/400 and I'm using IBM.Data.DB2.iSeries however, I don't know where I can get the DLL or library from.

Is it free? and where can I get it?

Regards,
ak
akohanAsked:
Who is Participating?
 
morguloCommented:
One of the returned column type is not supported by provider. It could be a problem with service pack. You can check for servicepacks: http://www-03.ibm.com/systems/i/software/access/windows/dotnet/index.html
If it doesn't work cast unsupported column type. Try to remove and add columns from query to fing which columns are invalid.
0
 
akohanAuthor Commented:


Hi thanks for the link... I got it work and now my code runs but the problem is that when I run a query
I get


System.InvalidCastException was unhandled
  Message=The data type returned is currently not supported by the provider.

Do I need to update it or any service pack related to solve this issue?

Thanks.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
morguloCommented:
Could you get more information? Show me code where you get an exception.
0
 
akohanAuthor Commented:

Sure.

Error happens on line 6 where Fill() method is called.




try
            {
                db.Open();

                adpt.SelectCommand = new iDB2Command(txtSQL.Text, CommandType.Text, db);
                adpt.Fill(ds);

Open in new window

0
 
akohanAuthor Commented:

could be a service pack problem? do I need to upgrade the library?

0
 
akohanAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.