Connect ASP.net(2.0) to AS400 Iseries w/ DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al G - 14 Dec 2007 19:06 GMT

Can someone tell me what I need to get connected to our AS400?

I am trying to write an app in VS2005(Data source, Gridview) that requires
data from files on our AS400. I've downloaded DB2, and installed it, but
apparently I need an additional product, "DB Connect" to actually make a
connection. "DB connect" says that it will only display tables with a type
of "T", and as far as I know, we are using files, not tables on the 400.

Can someone point me in the right direction?

Al G

Reply to this Message

Karl Hanson - 14 Dec 2007 20:43 GMT

Al G wrote:

> Can someone tell me what I need to get connected to our AS400?
>
[quoted text clipped - 5 lines]
>
> Can someone point me in the right direction?

Tables are physical files in DB2 for i5/OS (System i | iSeries | AS/400).
publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzatc/rzatcterminology.htm

Most likely you are using "DB2 Connect":
www-306.ibm.com/software/data/db2/db2connect

There should be no problem accessing physical files via DB2 Connect, as
long as the physical files are "externally described". All tables and
views created via SQL DDL are externally described files. All physical
and logical files created using DDS (to describe fields/columns) are
externally described - for example using CRTPF ... SRCFILE().

An alternative to DB2 Connect might be the iSeries Access .NET provider:
www-03.ibm.com/systems/i/software/access/windows/dotnet/index.html

--
Karl Hanson

Reply to this Message

Al G - 14 Dec 2007 21:03 GMT

> Al G wrote:
>> Can someone tell me what I need to get connected to our AS400?
[quoted text clipped - 25 lines]
> --
> Karl Hanson

Thanks Karl,

Too many new terms, I guess. I've found an older trial version of DB2
Connect, V8.2, so will load that and see if I can connect.

Al G

Reply to this Message

Al G - 15 Dec 2007 00:19 GMT

>> Al G wrote:
>>> Can someone tell me what I need to get connected to our AS400?
[quoted text clipped - 32 lines]
>
> Al G

I installed the trial version DB2 Connect v8.2, and it required that I
un-install the IBM DB2 v9.1 that I was trying to test.
VS2005 doesn't show DB2 as one of the possible connection types now. I
presume there are components out there that I am missing.
Do I need to add anything to the 400? We're at V5R4 now.

Thanks

Al G

Reply to this Message

Stefano P. - 15 Dec 2007 22:20 GMT

>>>> Can someone tell me what I need to get connected to our AS400?

>> Too many new terms, I guess. I've found an older trial version of DB2
>> Connect, V8.2, so will load that and see if I can connect.

> I installed the trial version DB2 Connect v8.2, and it required that I
> un-install the IBM DB2 v9.1 that I was trying to test.
[quoted text clipped - 3 lines]
> Thanks
> Al G

May be that installing iSeries Access (V5R4) on pc with VS2005 gives you
the "drivers" you need; usually we do this...
...and this gives our pc developers the tools (iSeries Navigator) to
control DB on iSeries/system i server.

For what I know (on i5/iSeries servers I control) you don't need to
install anything on "AS/400" server.
Check instead that the desired "host servers" are started on iSeries:
you may ask it to your iSeries administrator or check it from VS2005
client from command line using CWBPING your_iseries_net_name and
controlling for "Data Access".
http://www.itjungle.com/fhg/fhg082907-story03.html

HTH
Stefano P.

Signature

"Niuna impresa, per minima che sia,
può avere cominciamento e fine senza queste tre cose:
e cioè senza sapere, senza potere, senza con amor volere"
[Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere" dall'indirizzo email ;-)

Reply to this Message

Karl Hanson - 17 Dec 2007 00:58 GMT

Al G wrote:

>>> Al G wrote:
>>>> Can someone tell me what I need to get connected to our AS400?
[quoted text clipped - 39 lines]
>
> Al G

Nothing else is needed on the System i - all DB and communications
support is in the base i5/OS (aka OS/400). DB2 Connect communicates via
DRDA. The InfoCenter topic "Distributed Database Programming" has more
info on DRDA here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/ddp/rbal1
kickoff.htm

The DRDA TCP/IP server support in i5/OS can be started with this command:
===> STRTCPSVR SERVER(*DDM)

You can see/configure the server relational database (RDB) name with
this command:
===> WRKRDBDIRE
The entry with remote location *LOCAL represents the server RDB.

If you decide to use the iSeries Access .NET provider, you'll want to
ensure the database "host server" support is active.
===> STRHOSTSVR SERVER(*DATABASE)

--
Karl Hanson

Reply to this Message

Al G - 17 Dec 2007 15:00 GMT

> Al G wrote:
>>>> Al G wrote:
[quoted text clipped - 63 lines]
> --
> Karl Hanson

Thank you gentlemen, I'll look into it.

Al G

Reply to this Message