× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yep....as long as you're using the MSQuery part of Excel to get the data.

Data transfer refers to the "Data transfer from iSeries Server" and "Data transfer to iSeries Server"
utilities found in Programs-->IBM iSeries Access for Windows.

**NOTE**: the licensed data transfer utilities can also be invoked via the Excel add in "iSeries
Access Data Transfer" and are shown on the Excel data menu as "Data transfer from iSeries..." and
"Data transfer to iSeries..."

So you can't use them without a license, even thought they may show on the Excel menu.

But you can install the ODBC driver and in Excel do Data->Import External Data-->New Database Query
and pull all the data you want to your hearts content without a license.

In Access, you can import tables or link to tables using ODBC all without a license.

HTH,
Charles


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
GUY_HENZA@xxxxxxxxxxxxxx
Sent: Tuesday, December 11, 2007 2:52 PM
To: Midrange Systems Technical Discussion
Subject: Re: Where do I get drivers to allow a GIS software package


So I can load ODBC drivers on all the PC's and download data from the
iSeries files to MS Access or Excel and they don't constitute a seat?

Sounds like a five year old explaining he was playing in the mug in the
front yard because he was told he can't play in the mud in the back yard.

Regards,

Guy





"Michael Ryan"

<michaelrtr@xxxxxxxx To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
m> cc:

Sent by: Subject: Re: Where do I get drivers to allow a GIS
software package
midrange-l-bounces@m

idrange.com





12/11/2007 02:38 PM

Please respond to

Midrange Systems

Technical Discussion









ODBC isn't data transfer. Data transfer is file transfer.

On Dec 11, 2007 2:37 PM, <GUY_HENZA@xxxxxxxxxxxxxx> wrote:

OK, what are you going to do with a driver other than Data Transfer?

Regards,

Guy





"Wilt, Charles"
<WiltC@xxxxxxxxxx> To: "Midrange
Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent by: cc:
midrange-l-bounces@m Subject: RE: Where do
I get drivers to allow a GIS software package
idrange.com


12/11/2007 02:28 PM
Please respond to
Midrange Systems
Technical Discussion






Nope, from the manual the only thing that requires a 5722-XW1 license
are:

The following components require an iSeries Access for Windows license:
* PC5250 Display and Printer Emulator
* Data Transfer


Charles


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
GUY_HENZA@xxxxxxxxxxxxxx
Sent: Tuesday, December 11, 2007 2:19 PM
To: Midrange Systems Technical Discussion
Subject: RE: Where do I get drivers to allow a GIS software package


Hmmmm, I thought loading the drivers on a PC constituted a CA seat.

Regards,

Guy





"Wilt, Charles"

<WiltC@xxxxxxxxxx> To: "Midrange
Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Sent by: cc:

midrange-l-bounces@m Subject: RE: Where do
I
get drivers to allow a GIS
software package
idrange.com





12/11/2007 02:09 PM

Please respond to

Midrange Systems

Technical Discussion









You don't need DB2 Connect, which is an extra cost item.

iSeries Client Access includes ODBC, OLEDB, and .NET drivers for
accessing
the i5 DB.

The drivers are no-charge parts of iSeries Access, which also includes
iSeries Navigator and its "Run
SQL Scripts" utility. So you don't have to pay for a CA license to
install
and use them.

Charles


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Tuesday, December 11, 2007 1:45 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Where do I get drivers to allow a GIS software package

Keith,

Thanks very much for the information. The folks that want to talk to
DB2/400 wish to do so from ESRI
ArcMap 9.2 and ESRI ArcCatalog 9.2. I'd like to show them their long
held
position that the i5 and
DB2/400 is hard to access is not true. I'm thinking they would have to
use
something like DB2 Connect
and the DB2/400 driver therein and configure the access via Microsoft's
ODBC configuration function.
Am I going down the right road and if so please steer me correctly on how
to configure their Windows
applications, mentioned above, so they can query DB2/400 from those
applications. If I'm not going
down the right road, please steer me correctly as well.

Thanks,

Dave







As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.