How to connect IBM DB2 for ODBC and CLI

This article explains the use of IBM DB2 Driver for ODBC and CLI also describes how it is connected
  • 2273

Introduction to CLI :

CLI stands for Call Level Interface. The goal of this interface is to increase the portability of application by enabling them to become independent of any one database vendor's programming interface. The IBM DB2 Driver for ODBC and CLI provides runtime supports for the DB2 CLI application programming interface(API) and the ODBC API. Though the DB2 client and DB2 runtime client both supports to DB2 CLI and ODBC APIs, this driver is not a part of either DB2 client. The driver has a much smaller footprint than the DB2 Client and the DB2 Runtime Client.

Syntax :

Driver={IBM DB2 ODBC DRIVER};Database=database_name;Host Name=server_add;Port=port_num;Protocol=TCPIP;uid=user_name;Password=password;

Connection string used to connect IBM DB2 Driver for ODBC and CLI is given below

Driver={IBM DB2 ODBC DRIVER};Database=database_name;Host Name=server_add;Port=1234;Protocol=TCPIP;uid=user_name;Password=password;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.