RE: Access iSeries from windows and odbc question

["Chris Payne" <CPayne@xxxxxxxxxxxxxxx>]

When you install client access, it lets you select which portions you
want to install. I have never tried, but you might be able to install
the ODBC drivers all by themselves.

Chris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Thursday, April 21, 2005 1:46 PM
To: Midrange Systems Technical Discussion
Subject: RE: Access iSeries from windows and odbc question

Hum,

That's tough.  AFAIK, Excel and Access can use only ODBC drivers.  So
you could do it, but you'd need an ODBC-JDBC Bridge.  I found at least
one out there, but it is a commercial product.

Probably easier and cheaper ($free) to install CA.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Mitchell, John
> Sent: Thursday, April 21, 2005 12:32 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Access iSeries from windows and odbc question
> 
> 
> Do you have any advice for making that work with MS Access 
> and MS Excel?
> 
> > -----Original Message-----
> > From: Wilt, Charles [mailto:CWilt@xxxxxxxxxxxx]
> > Sent: Thursday, April 21, 2005 9:53 AM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: Access iSeries from windows and odbc question
> > 
> > Nope.
> > 
> > You have to install the base iSeries Access product.
> > 
> > Could you use JDBC?  That driver is easily redistributed.
> > 
> > Charles Wilt
> > iSeries Systems Administrator / Developer
> > Mitsubishi Electric Automotive America
> > ph: 513-573-4343
> > fax: 513-398-1121
> > 
> > 
> > > -----Original Message-----
> > > From: midrange-l-bounces@xxxxxxxxxxxx
> > > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of 
> Mitchell, John
> > > Sent: Thursday, April 21, 2005 10:40 AM
> > > To: Midrange Systems Technical Discussion
> > > Subject: RE: Access iSeries from windows and odbc question
> > >
> > >
> > > Is there any way to get the ODBC driver separated from Client
> > > Access?  I
> > > would like to use it but I don't want to install the full
> > > version to get
> > > just that portion.
> > >
> > > Thanks in advance for any help!
> > >
> > >
> > > --
> > > This is the Midrange Systems Technical Discussion
> > > (MIDRANGE-L) mailing list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > >
> > 
> > --
> > This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.