Re: Connecting to IBM AS 400 or I5
- From: Bob Hairgrove <NoSpamPlease@xxxxxxxx>
- Date: Fri, 13 Jul 2007 17:52:29 +0200
On Fri, 13 Jul 2007 07:48:00 -0700, Jerry C <jerryed@xxxxxxxxxxxxx>
wrote:
There is a DB2 database on it. I was looking on the web and there is some
mention of a DB2 .net data provider. is this the best way to connect to a
database on these machines. More important is there some install and
programming guidence about this subject
The DB2 database which is built into the AS/400 operating system is
not exactly the same DB2 which runs on other systems -- it is
actually DB2/400. Depending on how AS/400 is set up, you might find
that it doesn't behave as one would expect a typical RDBMS to behave.
For example, transactions are not possible unless journaling has been
enabled on the library (schema); otherwise, everything always runs in
auto-commit mode, and it is sometimes not possible to change this
from the client. Also, stored procedures cannot be used on older
AS/400 installations unless there is a C compiler available on the
server, and some AS/400 shops do not have it installed (for whatever
reasons ... usually security).
For simple things, ODBC works well enough, though. Any of the .NET
clients will probably access the data through an underlying ODBC
layer unless IBM has supplied a native client in the meantime.
--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.
- References:
- RE: Connecting to IBM AS 400 or I5
- From: WenYuan Wang [MSFT]
- RE: Connecting to IBM AS 400 or I5
- Prev by Date: RE: Connecting to IBM AS 400 or I5
- Next by Date: SQLGetData/NUMERIC field in MS Access database
- Previous by thread: RE: Connecting to IBM AS 400 or I5
- Next by thread: Re: Connecting to IBM AS 400 or I5
- Index(es):
Relevant Pages
|
