Connect to as400 using sql
<p>I would think this would be a fairly common thing, and easy to find in google, but so far I haven't had much luck.  I would like my application to connect to the i-series AS400 system using some method, run an SQL statement over an AS400 physical file, return a result set, and then have my visual c# program process the result set.  I've heard of ADODB, ODBC, DB2, and OLEDB.  Can someone show me an example of the syntax for getting one of these methods to work?  I'd prefer to use a method that isn't dependent on having certain software such as client access, and am trying to avoid using something like ODBC due to the fact you have to configure the DSN.  I've searched and searched, but the most code I can find is what the connection string should look like.  Any help is appreciated!</p>

<p>Thanks!</p>
