current community chat Stack Overflow Meta Stack Overflow Stack Overflow Careers your communities Sign up or log in to customize your list. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site Stack Overflow Questions Jobsbeta Tags Users Badges Ask Question Sign up × Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: up vote 1 down vote favorite I need to connect to remote DB2 from local SQL Server 2008 R2. I don't want to use linked servers. 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. sql-server db2 odbc driver share|improve this question edited Aug 20 '13 at 18:05 putvande 10.4k31134 asked Aug 20 '13 at 18: 5 No free solution? I need to access the database in the DB2 server. If it is not free to get odbc drivers, can you suggest any other way to connect to DB2 other than linked server? – Chow Aug 20 '13 at 18:58 add a comment | 1 Answer 1 active oldest votes up vote 2 down vote accepted You can download DB2 clients for your DB2 version from here: Client software is free. share|improve this answer answered Aug 20 '13 at 19:24 mustaccio 8, Thanks Mustaccio – Chow Sep 5 '13 at 12:41 add a comment | Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. asked 2 years ago viewed 24526 times.
Abstract This document contains information about the stand alone IBM Data server driver for ODBC and CLI Versions 9.1, 9.5, 9.7, 10.1 and 10.5. Briefly described below are the following topics: Overview, License, Download, Installation, and Related Information. Content Overview License Download Installation Related information What is it? Starting from DB2 Version 9.1, there is a separate stand alone CLI and ODBC driver called the IBM® Data Server Driver for ODBC and CLI. This driver is installed and configured separately and supports a subset of the functionality of the IBM® Data Server Clients. It Provides runtime support for applications using CLI APIs, or ODBC APIs without the need of installing the Data Server Client or the Data Server Runtime Client. This driver is available only as a compressed file, not as an installable image. Messages are reported only in English. The IBM Data Server Driver for ODBC and CLI provides runtime support for: the DB2® CLI application programming interface ( API) the ODBC API the XA API database connectivity the DB2 Interactive Call Level Interface (db2cli) LDAP support (but LDAP cache is not saved to disk) tracing, logging, and diagnostic support. Who Uses it? The IBM Data Server Driver for ODBC and CLI is a lightweight deployment solution designed for independent software vendors ( ISV) deployments. Why use it? The driver has a much smaller footprint than the IBM Data Server Client and the IBM Data Server Runtime Client. You can have multiple installations of the driver on a single machine. You can install the driver on a machine that already has an IBM Data Server Client installed. You can include the driver in your database application installation package, and redistribute the driver with your applications. Under certain conditions, you can redistribute the driver with your database applications royalty-free. The driver can.
Download Now