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.