RE: Where do I get drivers to allow a GIS software package

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