RE: ODBC needed?

["McKeown, Andrew" <AMcKeown@xxxxxxxxxxx>]

CLI is supposed to work with those platforms but first the Oracle, SQL
etc need to be configured for DRBA.
Oracle, as I understand it, can also talk to the iSeries via a gateway
product available from Oracle.

SQL server can also communicated directly to the iSeries via client
access and ODBC.  The iSeries tables are defined as linked tables to the
SQL Server.   My experience with this technique has resulted in a stable
and reliable interface between the iSeries and SQL server provided that
you don't mind developing data transfers as a push/pull from SQL server.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Tuesday, April 12, 2005 10:03 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: ODBC needed?

That is true.  I guess, I mean to say, ODBC driver for some of the
popular database such as Oracle, mySQL, MS SQL...

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of McKeown, Andrew
Sent: Tuesday, April 12, 2005 8:57 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: ODBC needed?



They did provide a very close resemblance.  It's called CLI.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Tuesday, April 12, 2005 9:55 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: ODBC needed?

I've always wonder why IBM doesn't provide ODBC driver apis that cann be
executed from RPG, c,...

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Wilt, Charles
Sent: Monday, April 11, 2005 2:49 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: ODBC needed?


This has been often discussed on the list, check the archive for more
details.

Two options:
1) Third party program that resides on a PC
2) Use Java and a JDBC driver

HTH,

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.


Note: This message, including attachments, is from H&R Block Financial
Advisors, Inc.Member NYSE, SIPC.  This is not a solicitation of any
order to buy or sell.  The information contained herein is deemed to be
reliable but is in no way warranted by us as to accuracy or
completeness.  Messages are monitored and retained by the Company, but
the company cannot guarantee the security of this message.  The company,
and its associates, may not accept orders to affect purchase or sale
transactions, accept funds, securities, or similar instructions via
email.  If you are not the intended recipient of this message promptly
delete this message and notify the sender of the delivery error by
return email or calling 1.800.HRBLOCK and selecting the option for
'Financial Services'
You may not forward, print, copy, distribute, or use the information in
this message if you are not the intended recipient.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


Note: This message, including attachments, is from H&R Block Financial Advisors,
Inc.Member NYSE, SIPC.  This is not a solicitation of any order to buy or sell. 
 The
information contained herein is deemed to be reliable but is in no way 
warranted by us as
to accuracy or completeness.  Messages are monitored and retained by the 
Company, but
the company cannot guarantee the security of this message.  The company, and its
associates, may not accept orders to affect purchase or sale transactions, 
accept funds,
securities, or similar instructions via email.  If you are not the intended 
recipient of this
message promptly delete this message and notify the sender of the delivery 
error by
return email or calling 1.800.HRBLOCK and selecting the option for 'Financial 
Services'
You may not forward, print, copy, distribute, or use the information in this 
message if
you are not the intended recipient.