Hi Mark
Reading the other posts, my 2 cents worth are:
a) Go with the IBM .NET Managed Data Provider for a means of connection (its
faster, easier to install and simpler to code for than ODBC, OLEDB drivers).
Just treat the DB2/400 database as another SQL database (albeit with a few
minor differences in SQL syntax, mostly ?s and @s when adding command
parameters).
b) And, as many have pointed out, your C# code will execute on the Wintel
Server using IIS. SQL statements are issued against the DB2/400 database
just as they would be to any other SQL compliant database.
One recommendation, if you do want to try to future proof your (his or hers)
code then try the ASP.NET 2.0 ObjectDatasource controls, (they really are
worth the effort IMHO).
Regards
Maurice O'Prey
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [
mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Mark Allen
Sent: 03 July 2007 15:58
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] C## ASP connecting to AS/400 DB
We finally have a "web developer" on board. His experience is mostly in
using C## to develop ASP delivered pages. From my still limited knowledge
of web programming in general this is the process as I see it and would like
any input from y'all.
1. The actual "code" would be running on our Windows based IIS server.
2. We would need some type of connection from the IIS server to the AS/400
to retrieve the data (ODBC, JDBC, other options, best to use?)
3. The actual data retrieval and "eventually" updates would be done using
SQL within the C## ASP code or am I completely off base here?
midrange.com
