We have been using the Client Access ODBC drivers when accessing AS/400 data from our .net applications and SQL DTS/SSIS packages. Are there third party drivers that provide better performance or functionality?
+1
A:
I know this is on the other side of the hill, but I've been using JTOpen as a JDBC (well, Java ...) driver in a previous project. This is an OpenSource version of the IBM Toolbox for Java. As such it is usually some versions ahead of the IBM release and had fewer bugs. My experience with this driver was very positive.
mkoeller
2008-11-17 22:42:22
+1
A:
Our company is using the same Client Access drivers. As far as we know there are no other ones available. One issue we ran into last year was that there were no 64-bit drivers available so our servers that have applications connecting to the AS/400 must be 32-bit.
Jon Erickson
2008-11-18 00:04:41
A:
You can use the Windows built-in drivers to connect, but my guess is the the IBM driver would be faster.
Are you seeing a performance hit or are you just trying to squeeze out more performance? If it is the first one, look at your system to see if it is sized properly. At an old job, the system was sized too small for what we where using it for. Some simple queries took minutes to run. If it is the latter, maybe try adding some more RAM to the System i.
Mike Wills
2008-11-18 15:08:38
A:
I'm not sure if it's better performance but a quick google turns up Hit ODBC/400.
Paul Morgan
2008-11-18 15:59:29
A:
IBM has been consolidating their DB2 drivers, so the universal DB2 driver should be able to connect to DB2/400.
I have not tried it yet though. I'd like to hear experiences.
Thorbjørn Ravn Andersen
2009-01-26 15:37:57