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

[Al G]

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

[Karl Hanson]

Al G wrote:

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?

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

[Al G]

"Karl Hanson" <kc******@youess.ibm.comwrote in message
news:4762eb04$1@kcnews01...

Al G wrote:

>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?

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

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

[Al G]

"Al G" <ag*******@nospam.charter.netwrote in message
news:Uc*************@newsfe06.lga...

>
"Karl Hanson" <kc******@youess.ibm.comwrote in message
news:4762eb04$1@kcnews01...

>Al G wrote:

>>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?

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

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

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

[Stefano P.]

>>>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.
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

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.

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

[Karl Hanson]

Al G wrote:

"Al G" <ag*******@nospam.charter.netwrote in message
news:Uc*************@newsfe06.lga...

>"Karl Hanson" <kc******@youess.ibm.comwrote in message
news:4762eb04$1@kcnews01...

>>Al G wrote:
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?

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

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.

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

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/infoce...al1kickoff.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

[Al G]

"Karl Hanson" <kc******@youess.ibm.comwrote in message
news:4765c9ab$1@kcnews01...

Al G wrote:

>"Al G" <ag*******@nospam.charter.netwrote in message
news:Uc*************@newsfe06.lga...

>>"Karl Hanson" <kc******@youess.ibm.comwrote in message
news:4762eb04$1@kcnews01...
Al G wrote:
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?
>
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
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.

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

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/infoce...al1kickoff.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

Thank you gentlemen, I'll look into it.

Al G