沃梦达 / 编程问答 / php问题 / 正文

使用 PDO 连接 IBM 数据库

Connect IBM database using PDO(使用 PDO 连接 IBM 数据库)

本文介绍了使用 PDO 连接 IBM 数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

I tried connect IBM database through PDO using below code. But, it is not working

try {
    $db = new PDO("odbc:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=BLUDB;HOSTNAME=hostname;PORT=50000;PROTOCOL=TCPIP;", "username", "password");
    echo "<pre>";
    print_r($db);
    exit;
} catch (PDOException $e) {
    echo $e->getMessage();
}

I got below error for the same

SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have also added below code in php.ini file

extension=php_pdo.dll
extension=php_pdo_ibm.dll
extension=php_ibm_db2.dll

Could anyone suggest me, how I can connect with IBM database?

解决方案

there is different driver name for some computer, this is the list of driver you can try:

  • DRIVER={iSeries Access ODBC Driver};
  • DRIVER={IBM i Access ODBC Driver};

and try to use System instead of HOSTNAME

DRIVER={iSeries Access ODBC Driver};DATABASE=BLUDB;System=hostname;PORT=50000;PROTOCOL=TCPIP;

oh, and I'm using DRIVER={IBM i Access ODBC Driver};

这篇关于使用 PDO 连接 IBM 数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:使用 PDO 连接 IBM 数据库

基础教程推荐