Jun 02, 2014 DB2 10.1 install to Windows Server 2012 R2 Standard 64 bit. Clients on 2008 R2 server with no issues. DB2 10.1 install to Windows Server 2012 R2 Standard.
In this post I describe how to install the IBM DB2 ODBC driver on Windows Server 2008 R2 SP1 and how to configure a data source to connect to a DB2 database. Rca wireless receiver ir emitter model d930 manual treadmill. Environment Client OS: Windows Server 2008 R2 SP1 64b Database Host OS: AIX 6.1 RDBMS: DB2 9.7 Procedure • Download the IBM DB2 ODBC driver from the IBM download website (You only need the ODBC driver, not the complete client). • Unzip the ODBC driver on the local machine, for example, in C:/Programs Files/IBM.
• Register the driver (run the Command Prompt as Administrator). • Open ODBC data source administrator • Add a new data source • Create the db2dsdrivercfg with the minimum DSN and database information • Select “IBM DATA SERVER DRIVER for ODBC” from the diver list and press Finish • Enter the Data source name, it is recommend to be the same as the database name, and the description and press on the button “Add” • You do not need to add any parameter, need to get in there in order to activate the button OK of the “ODBC IMB Driver – Add” dialog box. • Close the “CLI/ODBC setting” dialog box. • Click on “OK” on the ODBC IBM DB2 Driver – Add” dialog box. Test connectivity • In the ODBC data source manager, select the new data sources and click on “Configure”.
• Enter the userid and password of the DB2 user and click on “Connect”. If connectivity is successful, you will receive a confirmation message. Your ODBC data source for DB2 is ready to use.
There are still corporations running older versions of DB2 from the mainframe in which newer OS’s are connecting to. Since the agents are not being upgraded it is getting harder and harder to connect to the older databases. This was the case I ran into when connecting a Windows 2008 R2 server connecting to DB2 7.2 running on a Mainframe. This assumes you have the agent as currently there is no download available and it will come from the vendor. Double click on DB272.exe to start install.
Click ok when receiving admin rights error Once installed start Client Configuration Assistant tool. Click on the properties for each of the connections and check the Register this database for ODBC box and click OK. Do this for all the connections listed and it will register them all as 32 bit ODBC objects.
At this point you will see the connections but they will not work properly due to the entry will try to use the Microsoft supplied dll and switch to C: programs SQLLIB bin DB2CLI.DLL. You correct this issue by Open the registry and navigate to the key Point ODBC to the correct driver. HKLM SOFTWARE Wow6432Node ODBC ODBC.INI Change Driver Value to C: programs SQLLIB bin DB2CLI.DLL from c: Windows System32 for the following Keys CSDP CSDQ CSDT DSN DSNP DSNQ PIDP PIDQ PIDT Save the changes and you are now ready to create ODBC connections to the database.