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 | 评论(171) | 引用(0) | 阅读(52152)
nehir subtitrate in romana Email Homepage
2021-8-21 19:20
Dacă sunteți în căutarea seriale turcesti subtitrat in romana. filme fast team iti ofera toate seriale turcesti cu subtitrat
turske
2021-8-30 15:10
Hvala na ispravci. ažuriramo turske serije sa prevodom. gledajte online turske serije online sa prevodom https://turskeserije.org/
balaj Email Homepage
2021-9-10 22:10
Mobdro apk is an online streaming application for android users. The user can find links to youtube videos as well using mobdro apk.https://supermodapk.com/mobdro-apk/
balaj Email Homepage
2021-9-10 22:10
hy
leadstackert1 Email Homepage
2021-10-30 07:54
This is one of the best website i have ever seen. . I visit regularly. Hope to have more quality items. Also I would like to share some information also. Check out <a href=https://www.leadstacker.com//">clickfunnels</a>
leadstacker1 Email Homepage
2021-10-30 08:41
This is one of the best website i have ever seen. . I visit regularly. Hope to have more quality items. Also I would like to share some information also. Check out <a href=https://www.leadstacker.com//">clickfunnels</a>
hyiptempo2 Email Homepage
2021-10-31 06:45
Bitfinex could be a powerful CryptoCurrency HTML five template. Build no matter you prefer <a href=https://hyiptempo.com/">btc templates in html</a> with this template that appears effortlessly on-point in Bitcoin
hyiptempo3 Email Homepage
2021-10-31 06:46
We provide Cheap script with powerful features. Visit this page to know more about <a href=https://hyiptempo.com/">cheap hyip script</a> our pricing and buy hyip script with advanced geatures
seo Email
2021-11-14 19:16
Admiring the time and effort you put into your blog and detailed information you offer!.. สมัครlive22
rega Email Homepage
2021-11-28 18:05
great article keep itup..Winning Eleven 2018 APK
KevinDurant Email
2021-12-4 16:22
The classic mind games existed decades ago, who still remembers well now? I don't want to talk about their appeal but about the value, they bring to players. In addition to being highly entertaining, mind games also help us passively train our brains, and I think that's very helpful. One of those classic games is Sudoku, currently, sudoku is being collected by Sudoku 247 and is completely free for everyone. Why don't we try to experience and evaluate this game when the benefits it brings are undeniable?
seo Email
2021-12-19 03:08
Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our.  สมัคร 918kiss
Hibbah Email
2022-1-7 15:31
Your work is truly appreciated round the clock and the globe. It is incredibly a comprehensive and helpful blog.  Dankwoods blunt
AMKOP Email
2022-1-9 14:15
it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity..  รับทำระบบพนัน
seo Email
2022-1-10 04:54
Great write-up, I am a big believer in commenting on blogs to inform the blog writers know that they’ve added something worthwhile to the world wide web!..  เว็บสล็อตคนเล่นเยอะ
ALIK Email
2022-1-10 12:12
It is a fantastic post – immense clear and easy to understand. I am also holding out for the sharks too that made me laugh. Free Baby Samples By Mail 2022
Hibbah Email
2022-1-11 23:19
I read that Post and got it fine and informative.  alexavegas
Hibbah Email
2022-1-12 19:25
Online gambling in Indonesia is so close to everyday life that even so-called slot machines are a common thing we see when friends play them, when they are together, or relatives when they rest where they are. free time, fill it with a slot machine. wrestle. online slots.  Situs Rhino88
Hibbah Email
2022-1-14 23:52
PharmaNoz.com | Official Health & Beauty Store - Discover The World Best Sellers For Hair Care, Skin Care, Supplements & More: Alopexy, Pantogar, Cadiveu Brasil Cacau , Biafine - World Free Shipping  Brasil Cacau Keratin Treatment Kit
Hibbah Email
2022-1-15 15:18
I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also   Cartão de Todos
分页: 4/9 第一页 上页 1 2 3 4 5 6 7 8 9 下页 最后页
发表评论
表情
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
打开HTML
打开UBB
打开表情
隐藏
记住我
昵称   密码   游客无需密码
网址   电邮   [注册]