RE: openlink odbc bridge Macintosh Query on iSeries

["Coy Krill" <coyk@xxxxxxxxxx>]

Good to know. Did you try their ODBC-JDBC bridge? I've been going to try
it on a Mac OS 10.6.6 machine but hadn't gotten to it yet. I'd be
interested in your experience if you had.

Coy Krill
Database Administator/Data Analyst
Whidbey Island Bank

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Robin M. Moore
Sent: Friday, 18 March, 2011 3:02 AM
To: Midrange Systems Technical Discussion
Subject: openlink odbc bridge Macintosh Query on iSeries

Thanks all.. 
Just want to let you know, that OpenLink odbc Bridge works with excel
and ms query to allow you to connect and do GUI drop and drag or SQL
queries on the iSeries returning data to Excel
Doesn't do as well as windows but work pretty well.. 
This product allows you to set up a window machine to have the ODBC dsn
for the iseries and then the Mac can access this easily to connect to
the iseries.. 
Robin

Mr. Robin Moore    
Francis Marion University
Director of Campus Applications and
                Data Services (CADS)
SACC 102C       843-661-1393
email          Rmoore@xxxxxxxxxxx
Web page   http://departments.fmarion.edu/cads
Campus Technology portal   http://my.fmarion.edu

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
Sent: Wednesday, March 16, 2011 11:02 AM
To: Midrange Systems Technical Discussion
Subject: Re: openlink odbc bridge

Have you looked into possibly using jdbc.

On Wed, Mar 16, 2011 at 10:41 AM, Robin M. Moore <RMoore@xxxxxxxxxxx>
wrote:

> Jack.. I have windows OS also.. that is what I mainly use.. also have
> hundred of windows on campus.. and  it works great..
> I'm trying to help some faculty and staff on about 75 Macs  to allow
them
> to access data on the iSeries..
> I working on ODBC Bridge now.. for the Macs.. with OpenLink..
>
> you know of some other ODBC bridge?
> I have worked with OpenLink and easy soft..
>
> I looking at the ODBC.. for msquery  through excel..
> I know there is a mac db2 not sure how well it would do easy drop and
drag
> queries
> Robin
>
>
>
>
>
>
>
>
>
> I take it you don't have a windows OS then.  What about a odbc bridge
> possibly for connection??
>
> You want MAC-OS to IBM DB2.
>
> On Wed, Mar 16, 2011 at 9:32 AM, Robin M. Moore <RMoore@xxxxxxxxxxx>
> wrote:
>
> > OS X 10.6.6
> > I was also working with Easysoft but they told me that they didn't
> support
> > 10.6.6 on there odbc bridge..
> >
> > Mr. Robin Moore
> > Francis Marion University
> > Director of Campus Applications and
> >                Data Services (CADS)
> > SACC 102C       843-661-1393
> > email          Rmoore@xxxxxxxxxxx
> > Web page   http://departments.fmarion.edu/cads
> > Campus Technology portal   http://my.fmarion.edu
> >
> >
> > -----Original Message-----
> >  From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> > midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
> > Sent: Wednesday, March 16, 2011 9:00 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: openlink odbc bridge
> >
> > Robin, what desktop OS.
> >
> > On Tue, Mar 15, 2011 at 5:43 AM, Robin M. Moore <RMoore@xxxxxxxxxxx>
> > wrote:
> >
> > > Has anyone got the ODBC to ODBC Bridge by OpenLink to work..
> > > To connect to the iseries..
> > > Thanks Robin
> > > Mr. Robin Moore
> > > Francis Marion University
> > > Director of Campus Applications and
> > >                Data Services (CADS)
> > > SACC 102C       843-661-1393
> > > email          Rmoore@xxxxxxxxxxx
> > > Web page   http://departments.fmarion.edu/cads
> > > Campus Technology portal   http://my.fmarion.edu
> > >
> > >
> > > -----Original Message-----
> > > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> > > midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Lennon_s_j@xxxxxxxxxxx
> > > Sent: Thursday, March 10, 2011 8:11 PM
> > > To: midrange-l@xxxxxxxxxxxx
> > > Subject: Re: Macintosh Query on iSeries
> > >
> > > I think I missed some of this thread, but if you want a GUI client
to
> go
> > > against the iSeries try SQuirreL.  It is an open source tool that
is
> > > Java based using JDBC, so you also need JT400.  I have not used
the Mac
> > > version, but one is available.  I think you will be pleased with
it.
> > > http://www.squirrelsql.org/
> > >
> > > There was a recent article about it at mcpressonline.com.
http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-grap
hical-tool-that-you-can-use-for-all-your-databases.html
> > > Sam
> > >
> > >
> > >
> > > On 3/10/2011 11:23 AM, Robin M. Moore wrote:
> > > > Thanks
> > > > Jason, Mark, pete and Mike..
> > > > I'm looking in to some jdbc.. I was hoping that someone would be
> using
> > > some.. and give me some direction to make it close to how windows
works
> > with
> > > excel and MS query..
> > > > Thanks again..
> > > > Robin
> > > >
> > > > Mr. Robin Moore
> > > > Francis Marion University
> > > > Director of Campus Applications and
> > > >                  Data Services (CADS)
> > > > SACC 102C       843-661-1393
> > > > email          Rmoore@xxxxxxxxxxx
> > > > Web page   http://departments.fmarion.edu/cads
> > > > Campus Technology portal   http://my.fmarion.edu
> > > --
> > > 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.
> --
>  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.