× 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.


  1.  Home
  2. MIDRANGE-L
  3. March 2011

RE: openlink odbc bridge Macintosh Query on iSeries

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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.