Configure SQuirreL SQL Client for DB2 for Linux, UNIX, and Windows May 19, 2018 Database, DB2 Tapio Vaattanen At least for me the default settings for SQuirreL DB2 driver didn’t work.
Active2 years, 7 months ago
I need to connect to remote DB2 from local SQL Server 2008 R2. I don't want to use linked servers. Windows defender download 64 bit windows 10. So I am searching for download and trying to install IBM DB2 driver, as Microsoft ODBC driver for DB2 comes with Host Integration Server is expensive.
putvande13.3k33 gold badges2525 silver badges4747 bronze badges
ChowChow
3 Answers
You can download DB2 clients for your DB2 version from here: http://www-01.ibm.com/support/docview.wss?uid=swg27007053
Use Windows Explorer to set up a share for the entire drive, or just for the directory where DB2 Client Application Enabler is installed. For example, you can install the DB2 Client Application Enabler to c:codesrvsqllib, then a share can be set up for the directory c:codesrv. DB2 Client Install on Linux. Allowing client machines to connect to a DB2 database is not as simple as regular databases. If you are using a client application, such as a Java web application, usually the application server has what is needed to configure a DB2 connection pool. However, if you need to access DB2 from the command line. How to install and configure DB2 ODBC driver. The 32-bit version of the ODBC Administrator can be found here: C: Windows SysWOW64 odbcad32.exe (Thanks to Grae for this comment) Now you have to setup a ODBC-driver for DB2. You can either make a System or User DSN. In this example i’m creating a User DSN. Go to the User DSN-tab and press the Add-button. db2-l How to find out the DB2 product installed in a client box? Posted by aritraroy on Jun 9 at 6:58 AM. Hi guys, if there is a Client box, where DB2 Client software is installed, and db2licm -l returns no results, how do I find out which PRODUCT of DB2 is installed? The DB2 iDataAgent is installed on the computer from which the iDataAgent secures data. (This computer is referred to as the Client computer in this install procedure.) Verify that the computer in which you wish to install the software satisfies the minimum requirements specified in System Requirements - DB2 i DataAgent and in System Requirements - Microsoft Windows File System i DataAgent.
Client software is free.
mustacciomustaccio15.2k99 gold badges4141 silver badges4444 bronze badges
The below link has a step by step guide that worked well for me
CidIbm Db2 Client For Windows
Cid1,18811 gold badge1414 silver badges3535 bronze badges
Db2 Client Tools For Windows
![Windows Windows](/uploads/1/2/4/8/124853471/466092822.jpg)
Both answers are correct, but only have the links to were the answers are.
- download the correct driver (called fix pack most of the time) you need from IBM
- extract the contents of the zip file to
c:program filesIBM
, I unzipped it inc:program filesIBMclidriver
- open a command prompt as administrator and change to the directory you just created and then go in the bin folder
- execute the following commands to install and register the odbc drivers
- Download bootrec for windows 7. check your odbc manager if the drivers are installed, this is depending on the version you selected (32 bit or 64 bit)
for the 32 bit version open your odbc data sources 32 bit otherwise open the odbc data sources 64 bit.
To open odbc data sources in windows versions 7 upwards
- press the windows key
- type
odbc
- click on the version you need (32 bit or 64 bit)
4,61299 gold badges2626 silver badges6060 bronze badges