How to install IBM db2 ODBC driver in Windows 7. Download the correct driver. For the 32 bit version open your odbc data sources 32 bit otherwise open the odbc. Users of V5R2 iSeries Access for Windows may notice that the following ODBC driver names are registered: 'Client Access ODBC Driver (32-bit)' 'iSeries Access ODBC Driver'. Software - iseries access odbc driver. Devart ODBC Driver for Salesforce, ODBC Driver for xBase, SQL Server ODBC driver (32/64 bit). We use both the old verision (6.1) and the newer java based version on windows 10. Our programmers prefer the java based, but I left all of our desktops on 6.1 and they work just fine after the systems were upgrade to win 10. IBM will not support if you have any issues while running the old version, but that does not mean it will not work with win 10. The only thing I ran into was using PDT for printers, it did not seem to work for us after the upgrade, but it was only a handful of PCs that we used PDT settings on a printer, so no big deal. We run Windows 10 and Server 2008/2012, and use the v7r1 client every day without a problem, both 32-bit and 64-bit, depending on the client O/S. We have Excel/VBA macro-enabled spreadsheets, VBScripts, and PowerShell scripts as part of our daily operations, including server side scheduled tasks. I use multiple sessions of the green screen every day. My boss uses the 'import data to Excel' function weekly. What I cannot tell you is anything about the AS400 system itself, it is a hosted service and we just connect to it. Yes IBM i ACS is the new java based Client Access replacement product that is supported on Windows 10. But to use that client on Windows 10 may require the upgrade of the OS from 5.3 to 5.4 but you probably should go to 6.1 and then to 7.1 There are many advantages in v6.1 and even more in v7.1 The jump to v6.1/v7.1 requires a conversion of objects. There is a tool/report you should use first to see any problem areas. If you have the room on the system, you may want to create another LPAR, restore your current system to it and test the upgrade. Again, since you are so far back, you may want to get some assistance. The following shows you how I got an ODBC connection to DB2 on a Windows Server 2008R2. After doing a search on the Internet I found that really helped me a lot. They do it a bit different. NEW If you also want to install the IBM Control Center you might want to look at this. This also installs the ODBC out-of-the-box. If your need a 32 or 64-bit version for Windows and DB2 version 9.7. You should look for something like this. On this you can find and download the ODBC-drivers that fits your system. I you don’t know what version of DB2 that you’re running, you can contact your DBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2019
Categories |