xixi

使用dblib连接sybase

php
2017/02/14

  1. 安装freetds

    1
    yum install freetds freetds-dev

  2. 安装pdo_dblib扩展

    1
    2
    pecl install pdo_dblib
    php --ri pdo_dblib # 验证扩展是否安装

  3. pdo连接

    1
    2
    3
    4
    5
    6
    7
    8
    $dsn = 'dblib:appname=PHP freetds;host=localhost:12345;dbname=abc';
    $user = 'username';
    $passwd = 'password';
    try {
        $dbh = new \PDO($dsn, $user, $passwd);
    } catch(\PDOException $e) {
        echo $e ->getMessage();
    }

*yum源没有freetds

1
2
3
wget http://www6.atomicorp.com/channels/atomic/centos/7/x86_64/RPMS/atomic-release*rpm
rpm -Uvh atomic-release*rpm
yum install freetds

CATALOG
Archive Tag
Total : 21
2017
JavaEE spring cloud mysql, database Java Spring Cloud Ribbon php docker linux jinfo java jit mysql nginx linux vmstat linux iostat soft spring