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



Hi Mark

One counterpoint to your assertion that IBM doesn't want people using DB2 for i is the JDBC driver - it's free.

Also, I see that DB2 Connect Personal Edition is bundled with Data Studio - and that is free. I don't know if this helps with the original issue, which has since been resolved with the JDBC driver.

I see a price of DB2 Connect of $562 - that'd be prohibitive, I agree - maybe.

But maybe everyone could get Data Studio - I don't know what the restrictions are on its use.

HTH
Vern

On 7/5/2012 11:33 AM, Mark Murphy/STAR BASE Consulting Inc. wrote:
Sorry for the late reply, but I did want to clarify. DB2 Connect personal edition is simply a DRDA client for windows. It lets you connect to DRDA databases (specifically DB2 for i) from a windows client. I have looked at the pricing for this product, and it appears that IBM doesn't really want anyone using DB2 for i as an enterprise database since they have made the Windows client prohibitively expensive.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Gary Thompson
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 06/26/2012 11:10AM
Subject: RE: DB2 Connect vs. JTOpen jdbc driver

Mark,
I am not understanding your point, I guess mainly the "native client" part.

As far as I know "the native client" on i does not directly support
queries against non-DB2 remote DB.

We looked at DB2 connect and the price IBM quoted seemed high, and it
appeared to have more function than our project or future needs require,
so we could not justify the expense.
True, we did install a full blown DB, but that is part of the 3rd party
pick system we are installing, so this was not a deciding factor for us.

We did look at Scott Klement's service program and open source ArdGate
(which has a lot to recommend it) and are now using another 3rd party
product and are pleased with our results.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR BASE Consulting Inc.
Sent: Tuesday, June 26, 2012 8:35 AM
To: Midrange Systems Technical Discussion
Subject: RE: DB2 Connect vs. JTOpen jdbc driver

So using the native client is overkill but installing a full blown database isn't? Interesting.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Gary Thompson
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 06/25/2012 01:49PM
Subject: RE: DB2 Connect vs. JTOpen jdbc driver

My 2 cents is DB2 connect is overkill unless you have a large enterprise needing to connect to a mix of databases on a mix of servers with DB2 being the main enterprise db.

I have found going to/from MS Sql to DB2 relatively easy. One of my first projects used Access pass-through queries with an MS Sql Server back end that had an iSeries DB2 database connection.

After that, we did some .net based connections using C#.

All that is some years past, but, aside from licensing MS Sql server and .net developer tools, we had a relatively small budget.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean Eshleman
Sent: Monday, June 25, 2012 11:25 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: DB2 Connect vs. JTOpen jdbc driver

We purchased a Windows application that needs to connect to our System I box to retrieve data. The vendor thinks they need to use DB2 Connect to do that. I was wondering why they couldn't just use the JDBC driver that is available via the JTOpen toolbox. Could someone explain why you would need DB2 Connect?

Dean Eshleman
Software Development Architect

Everence Financial
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
www.everence.com<http://www.everence.com>






________________________________________
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
_______________

--






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.