AS/400 ODBC 驱动程序
当从 .net 应用程序和 SQL DTS/SSIS 包访问 AS/400 数据时，我们一直使用客户端访问 ODBC 驱动程序。 是否有可以提供更好性能或功能的第三方驱动程序？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
我们公司正在使用相同的客户端访问驱动程序。 据我们所知，没有其他可用的。 去年我们遇到的一个问题是没有可用的 64 位驱动程序，因此我们的具有连接到 AS/400 的应用程序的服务器必须是 32 位的。
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.
我知道这是在山的另一边，但我一直在使用 JTOpen 作为 JDBC (好吧，Java ...）驱动程序在以前的项目中。 这是 IBM Toolbox for Java 的开源版本。 因此，它通常是 IBM 版本之前的某些版本，并且错误较少。 我与这位司机的经历非常积极。
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.
您可以使用 Windows 内置驱动程序进行连接，但我猜测 IBM 驱动程序会更快。
您是否看到性能受到影响，或者您只是想挤出更多性能？ 如果是第一个，请检查您的系统，看看其大小是否正确。 在以前的工作中，系统的尺寸对于我们使用它的用途来说太小了。 一些简单的查询需要几分钟才能运行。 如果是后者，也许可以尝试向 System i 添加更多 RAM。
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.
我不确定它是否有更好的性能，但快速谷歌出现 点击 ODBC/ 400 。
I'm not sure if it's better performance but a quick google turns up Hit ODBC/400.
IBM 一直在整合他们的 DB2 驱动程序，因此通用 DB2 驱动程序应该能够连接到 DB2/400。
不过我还没有尝试过。 我想听听经验。
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.