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

["Wilt, Charles" <WiltC@xxxxxxxxxx>]

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