The 32-bit version of the ODBC Administrator can be found here: C:\Windows\SysWOW64\odbcad32.exe (Thanks to Grae for this comment) NB! If you have installed af 32-bit version of the ODBC-driver on a 64-bit system, then you have to look in the 32-bit version of the ODBC Administrator to find the driver. This will register the DB2 ODBC-driver in Data Sources (ODBC) on Windows. Go to the folder c:\program files\IBM\bin and type db2oreg1 –setup (Thanks to Noel for this comment). Go to the folder c:\program files\IBM\bin and type db2oreg1 –i (if you later want to uninstall it type db2org1 –u).
Excel odbc driver download windows 7 how to#
If you don’t know how to do this, you can take a look at this page. Start a Windows command-prompt as administrator. The files and folders in c:\program files\IBM, should look something like this. The path is optional, you can choose a different path if you want to or are using a 32-bit ODBC-driver. NB! You need to create an IBM-account to download the file.Ĭopy the content of ZIP-file containing the ODBC-driver that you just downloaded to c:\program files\IBM. If your need a 64-bit version of the ODBC-driver for Windows and DB2 version 9.7. The DB2-version can be found using the command DB2level.Ĭhoose either ODBC 32-bit or 64-bit for your DB2-version and download it for Windows. I you don’t know what version of DB2 that you’re running, you can contact your DBA. On this page you can find and download the ODBC-drivers that fits your system. If your need a 32 or 64-bit version for Windows and DB2 version 9.7. This also installs the ODBC out-of-the-box.
Excel odbc driver download windows 7 install#
If you also want to install the IBM Control Center you might want to look at this page. After doing a search on the Internet I found this page that really helped me a lot. The following shows you how I got an ODBC connection to DB2 on a Windows Server 2008R2.