RE: openlink odbc bridge -- MIDRANGE-L

I have and have it working on the Mac..
But it doesn't work with excel except with a good bit of set up.. and also not simple for the user..

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