PHP特區 : [轉貼]使用PHP+FreeTDS在Linux下連接MS SQLServer數據庫

#tar -xzvf freetds-0.63RC10.tar.gz
#./configure --enable-msdblib --prefix=/usr/local/freetds
#make
#make install

#cd /usr/local/freetds
#vi etc/freetds.conf

[MyServer2k]
host=192.168.27.20
port=1433
tds version=8.0

#bin/tsql -S MyServer2k -H 192.168.27.20 -p 1433 -U sa -P sa
1> use tbit_mcp
2> go
1> select count(*) from t_service
4
1> quit

#tar -xzvf  php-4.3.10.tar.gz
#cd php-4.3.10
#./configure --with-mysql --with-apxs2=/www/bin/apxs --with-mssql=/usr/local/freetds
#make
#make install

# vi dbconn.php

<?php
$hostname = "192.168.27.20:1433"; //MSSQL Server，注意一定要註明1433端口號，否則將無法連接
$dbuser = "sa"; //用戶名
$dbpasswd = "sa"; //密碼
$gPageSize= 3; //每頁顯示的記錄數

//連接數據庫
$db_id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("無法連接數據庫服務器！");
$db = mssql_select_db("tbit_mcp",$db_id) or die("無法連接數據庫！");

//執行查詢語句
$query = "select * from t_service order by service_id DESC";
$result = mssql_query($query);