Thanks. I got the Client Access ODBC driver installed and working for this. The consultant I was working with who knows Business Objects only knows Windows data access setup and was not sure where to drop the jdbc driver or even how to set the class path in Business Objects so we went with ODBC just to get to the point of seeing data. Which has been successful. Once the consultant is done I am going to look at switching to jdbc which I think will be more efficient and more transportable were we to ever move the BO server to non-Windows platform. I am sure there is a BO manual somewhere that can help.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Monday, January 24, 2011 4:04 PM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries V5R4 DB2 driver for Business Objects
I haven't played with Business Objects (the product by that name) but my java and tomcat experience says use the JDBC drivers in JT400 or JTOpen. JTOpen is the "public" version of JT400. You'll find the jt400.jar file within your Client Access installation path. You can download jtopen from jtopen.sourceforge.net.
JTOpen and JT400 are maintained by the same people. JTOpen has the latest stuff. JT400 has been fully vetted by the IBM testing process.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Friday, January 21, 2011 4:04 PM
To: Midrange Systems Technical Discussion
Subject: iSeries V5R4 DB2 driver for Business Objects
I want to connect an installation of a Business Objects server running on Windows 2008 SP2 to DB2 running on V5R4. Not sure of the best choice of driver and where to get it. Should I use the ODBC drive or OLE DB driver for .NET or the java ODBC driver? BO is the java version running under tomcat. Looks like either would work. Is anyone running Business Objects in this configuration and have any recommendations on best choice?
Thanks
--
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.
midrange.com
