Ubuntu通过APT配置开发环境
apt-get install vim
apt-get install sshapt-get install apache2
apt-get install redis-server
apt-get install subversion
apt-get install git-core
apt-get install php5
apt-get install php5-gdapt-get install php-pear
apt-get install php5-mysql
apt-get install libmysqlclient-dev
wget http://www.unixodbc.org/unixODBC-2.3.2.tar.gz
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz
wget pecl.php.net/get/PDO_MYSQL-1.0.2.tgz
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz
wget pecl.php.net/get/PDO_MYSQL-1.0.2.tgz
wget pecl.php.net/get/PDO_ODBC-1.0.1.tgz
git clone https://github.com/nicolasff/phpredis
phpize
./configure --prefix=/usr/local/unixODBC
./configure --prefix=/usr/local/freetds --with-unixodbc=/usr/local/unixODBC/ --with-tdsver=7.0
./congigure --with-php-config=/usr/bin/php-config5 --with-pdo-odbc=unixODBC,/usr/local/unixODBC
(如果错误,则试着修改congigure,更改相关的路径)
odbc.ini
[TEST1dsn]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = First Test DSN
Trace = No
Servername = myserver
Database = 51fanli
UID = trace
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = First Test DSN
Trace = No
Servername = myserver
Database = 51fanli
UID = trace
freetds.conf
[myserver]
host = mdb.zz.51fanli.it
port = 1433
tds version = 7.0
host = mdb.zz.51fanli.it
port = 1433
tds version = 7.0
测试
/usr/local/unixODBC/bin/isql -v TEST1dsn trace traceredis-cli
/usr/local/freetds/bin/tsql -S myserver -U trace -P trace