Linux 下 PHP 5.2.x 连接 SQL Server 数据库 FreeTDS 配置笔记

金山游戏KSG-逍遥网招聘系统工程师

轻量级开源简单队列服务 HTTPSQS 1.3 版本发布

大 | 中 | 小

[

2010-6-25 18:00 | by 张宴 ]

　　CentOS 5.4 Linux 下的 PHP（FastCGI）需要连接相关部门的SQL Server 2000数据库，配置了扩展FreeTDS扩展。

　　1、编译安装FreeTDS

mkdir -p /data0/software/
cd /data0/software/
wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar zxvf freetds-stable.tgz
cd freetds-0.82/
./configure --prefix=/usr/local/webserver/freetds --with-tdsver=8.0 --enable-msdblib
make && make install
cd ../

echo "/usr/local/webserver/freetds/lib/" > /etc/ld.so.conf.d/freetds.conf
ln -s /usr/local/webserver/freetds/lib/libsybdb.so.5.0.0 /usr/local/webserver/freetds/lib/libsybdb.so.4
/sbin/ldconfig

rm -f /usr/local/webserver/freetds/etc/freetds.conf
vi /usr/local/webserver/freetds/etc/freetds.conf

　　输入以下内容：

引用

[global]
        # TDS protocol version
;       tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512

        host = mssql.yourdomain.com
        port = 1433
        tds version = 8.0
        client charset = UTF-8

　　2、编译安装PHP自带MSSQL扩展
　　进入本地已存在的php-5.2.XX源码包目录：

cd /data0/software/php-5.2.XX/ext/mssql/
/usr/local/webserver/php/bin/phpize
./configure --with-php-config=/usr/local/webserver/php/bin/php-config --with-mssql=/usr/local/webserver/freetds/
make && make install

　　3、在php.ini配置文件中增加mssql.so

vi /usr/local/webserver/php/etc/php.ini

　　增加一行：

引用

extension = "mssql.so"

　　4、重启PHP FastCGI

/usr/local/webserver/php/sbin/php-fpm restart

　　5、测试文件（test_mssql.php）：

技术大类 » PHP/JS/Shell | 评论(197) | 引用(0) | 阅读(59827)

juner

2010-12-26 16:14

perfect,非常感谢

moro

2011-10-12 16:16

张SIR 你好，请问一下 FREETDS 怎样支持GBK的编码

louis vuitton uk

2011-11-22 17:12

This louis vuitton uk for sale belongs to the sounding just what are termed as Louis Vuitton vintage best sellers, many other products and services for the reason that range appearing companies.You will easily notice the unfold zippers of this coach outlet store online. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.Let us inspire your inner beauty with fine christian louboutin sale. Purse the elegance in bridal wedding. Enjoy the fashion.

armani watches

2011-11-23 10:13

If you are looking for armani Bags, our armani watches Handbags Canada outlet store is your first choice. We promise Original Packing and Best Discount,3-5 Workdays To Your Door!If you buy bags and purses of the latest new designs from the louis vuitton outlet now, you can enjoy special discounts. What else are you waiting for?After you choose the right kind of plants and the size pot for the plant.

wedding520

2011-12-27 15:53

ワイドネックライン、'V'ネックやボートネックラインは、一般にキャップスリーブとドレスのために選ばれている。ボートスタイルのネックラインと幅広いネックラインのためには、オフショルダーのキャップスリーブを追加することができます。オフショルダーのウエディングドレスは、数年以来、結婚式の摩耗で人気のパターンになっても流行で、今日でもあります。カラードレス格安.のこのスタイルで素敵に見える模様のオフショルダーの袖に行く同じシースのサテンからステッチ/オフショルダーのキャップスリーブの上に薄いと飾ったときに裾フレアのビットとシースのサテンのイブニングドレスとスパゲッティネックラインがすごい見えます。

freetds

2012-2-23 17:38

张大哥，我这边开发还需要 dblib 可是这个在这里再添加就会出现 --with-pdo-dblib=/usr/local/webserver/freetds/

configure: error: Cannot find FreeTDS in known installation directories。。

能帮忙解决下疑问嘛

fly

2012-3-29 10:14

http://webvk.com

jevonszmx

2012-4-24 23:07

我们网站一般使用freetds+unixODBC架构，效果也非常完美。

Hogan

2012-5-10 17:51

Mentre youre gestione di problemi complessi tra cui PAYE insieme con le imprese del prelievo, l'idea è sicuramente intelligente per acquisire specializzata fare qualcosa di sicuro si sta usando la vostra organizzazione. Self-employmentSelf lavoratori uomini e donne potrebbe anche fare pieno uso Hogan dei ragionieri in tutta Stansted, quando hanno l'effetto della loro prelievo unico e sì, è spesso sconcertante. Stare di fronte a una buona varietà prelievo può essere schiacciante, di conseguenza, il

hogan280

2012-5-10 18:05

Non tanto è stato fatto perché le accuse della ragazza giovane non si pensava in primo luogo. Né come la segnalazione di Hogan questo caso potrebbe portare ad un simile tipo di stereotipo e mito attorno alla violenza sessuale.

lllpaw

2012-6-29 17:59

./configure --prefix=/usr/local/webserver/freetds --with-tdsver=8.0 --enable-msdblib --with-tdsver 现在最高应该是7.1吧

徐票

2012-7-11 23:00

求教： freetds中的log 给出的例子是在/tmp/freetds.log，这个是绝对路径还是相对路径呢？我把前面的分号去掉后，没有找到这个tmp文件夹，这个应该怎么设置呢？？？

衡阳爱居

2012-8-14 11:30

衡阳爱居网,衡阳家居建材装修设计门户网站, http://www.0734aiju.com 芒堆淘宝返利网 http://www.mangdui.com 43网站目录,免费网站提交,软文发布 http://www.43473.com

lirourou77

2012-9-5 13:24

in a new mechanism of system to replace the old in medicine have medical mechanism, which is the cheap designer handbags
cattle nets", and click "online voting" found that, the original vote is paid, 1 yuan 1 ticket.

"If you have to vote online, by pay treasure, net silver or cell phone pays fee." HeXianSheng cheap designer clothes
said, let people will choose the doctors like this is a good thing, but if will pay it is stale, "so, mean who's money, who can election?"

【 operation 】 can buy tickets into batch quantity
discount designer handbags

According to HeXianSheng provide web site, reporter found "purple cattle nets", "popular activities" column in the article 1 is: ningxiang county "open the door the medical" advanced unit and "top ten doctors, top ten nurses, top ten technicians" selection activities to officially wholesale designer handbags

OWVPN

2012-12-25 15:03

好文章学习了，值得收藏！

磨延城

2013-10-21 20:39

磨途歌学习了

django

2013-11-30 19:42

Uggs Sale the ideal idea Coach Outlet Online enough time to search for many of reduction Ugg boot. Like big portions? If you began ready your apartment, Coach Outlet it's always best to consider the most effective way direct to the stage it could be to utilise your inventory throughout Coach Factory Outlet concern, or maybe you basically won't destination stuff not enough.we're anti- whitening tray because Coach Outlet Online i will be enjoy just get germ dog breeders

2014-2-25 14:41

IDRpoker.com Agen Texas Poker Online Indonesia Terpercaya
IDRpoker.com Agen Texas Poker Online Indonesia Terpercaya
Alfamart official partner merchandise FIFA piala dunia Brazil 2014

aaa

2014-7-9 18:10

not working my php is 5.3.27

aaa

2014-7-9 18:11

make: *** No targets specified and no makefile found. Stop.
59538308 qq

分页： 2/10