<div>
<a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaik%2Frzaikdotnetprovider.htm" rel="ugc nofollow">http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaik%2Frzaikdotnetprovider.htm</a>
</div>


http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaik%2Frzaikdotnetprovider.htm [http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Frzaik%2Frzaikdotnetprovider.htm]

<div>
<br />
<br />
Hi thanks for the link... I got it work and now my code runs but the problem is that when I run a query<br />
I get <br />
<br />
<br />
System.InvalidCastExceptio<wbr />n was unhandled<br />
&nbsp; Message=<b>The data type returned is currently not supported by the provider.</b><br />
<br />
Do I need to update it or any service pack related to solve this issue?<br />
<br />
Thanks.<br />

</div>




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.


<div>
Could you get more information? Show me code where you get an exception.
</div>


Could you get more information? Show me code where you get an exception.

<div>
<br />
Sure.<br />
<br />
Error happens on line 6 where Fill() method is called.<br />
<br />
<br />
<br />
<br />

<pre><code id="code-8098315">try
            {
                db.Open();

                adpt.SelectCommand = new iDB2Command(txtSQL.Text, CommandType.Text, db);
                adpt.Fill(ds);</code></pre>
</div>



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);

<div>
<br />
could be a service pack problem? do I need to upgrade the library?<br />
<br />

</div>



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



<div>
<div class="content wysiwyg-content">
<br />
Hello,<br />
<br />
I need to make an application talk to AS/400 and I'm using <i>IBM.Data.DB2.iSeries</i> however, I don't know where I can get the DLL or library from.<br />
<br />
Is it free? and where can I get it?<br />
<br />
Regards,<br />
ak
</div>
</div>



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

.NET referecnes (IBM)

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).