Active1 year, 6 months ago
Identify fixes. Select fixes Quick order Please wait. The Fix Central application is identifying the fixes you selected. When your order is ready, the results will be displayed. Session about to expire. Sep 25, 2009 IBM Data Server Runtime Client; IBM Data Server Client; IBM Data Studio. The IBM Data Server Runtime Client is usually used on servers and workstations that primarily have applications that need to connect to a DB2 database and possibly run some utilities, but don’t need any GUI tools to explore or administer the database. It includes many. It looks that is not that straightforward.quoting from IBM site: To access DB2/400 data on an iSeries system with an ODBC Driver, you must install the appropriate iSeries Access for Windows client on the 32-bit system that hosts the LEI server.
I need to connect to an IBM AS400 database from .NET. There is already a question on this over here:
Use IBM Installation Manager to select, download, and install only the code, features, or product extensions that you want. Product extensions allow you to extend your install beyond the Data Studio feature set.
However, that question is old and only fleetingly mentions the IBM i Access Client Solutions. I do have IBM i Access Client Solutions installed. I cannot find the download for IBM i Access for Windows on their site. I am using the nuget packages for IBM.Data.DB2 and IBM.Data.DB2.iSeries and the code works just fine on my other box where IBM i Access for Windows is installed.
Ibm Db2 Client Download
When I try and create a connection on this box:
I run into an error:
Unable to load DLL 'cwbdc.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
My question, then, is: What do I need to do to connect when I have IBM i Access Client Solutions installed, but not the (now deprecated according to IBM) IBM i Access for Windows?
Postscript: I installed a bunch of IBM crap hoping to find something that worked. For .NET development using IBM.Data.DB2.iSeries, it does not appear necessary to install the IBM i Access Client Solutions Base Package, the IBM data server driver package, or the IBM Database Add-Ins for Visual Studio. I ended up tracking down the deprecated IBM i Access for Windows. That got me up and running. I hope to still track down someone with credentials to download the newer IBM i Access Client Solutions - Windows Application Package so I can give it a try. ALSO, attempting to gather IBM AS/400 drivers for .NET is a much bigger pain in the ass than I expect it to be in 2018...
Jereme
JeremeJereme
1 Answer
ACS comes in two parts...
universal Java based components, such as the 5250 emulator and database tooling and JDBC drivers.
Platform specific components, for Windows this include ODBC, ADO and .NET drivers.
Sounds like you're missing the Windows components formally known as the IBM i Access Client Solutions - Windows Application Package
Unfortunately, the Windows Application Package must be downloaded from IBM's Entitled Systems Support (ESS) website.
This is the same place your IBM i admins would download OS upgrades or optional components of the OS. So they should be able to get you the package you need.
CharlesCharles12.6k11 gold badge1111 silver badges3232 bronze badges