PHP에서 MS-SQL접속 (freetds)

먼저 서버에 freetds 모듈이 설치되어있어야 합니다.
기본 설정파일의 위치는 아래와 같습니다.

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

# Global settings are overridden by those in a database
# server specific section
[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
 
# A typical Sybase server
[egServer50]
        host = symachine.domain.com
        port = 5000
        tds version = 5.0
 
# A typical Microsoft server
[egServer70]
        host = ntmachine.domain.com
        port = 1433
        tds version = 7.0

host 주소또는 IP를 입력하고
ms-sql에서 지정한 port를 기입합니다.
tds 버전은 ms-sql server 버전에따라 다릅니다.

<?
$mssql_cfg['server'] = '지정한 서버';
$mssql_cfg['user']   = '아이디';
$mssql_cfg['pass']   = '패스워드';
$mssql_cfg['db']     = '디비네임';
 
function MS_Conn(){
    Global $mssql_cfg;
 
    $conn = @mssql_connect($mssql_cfg['server'], $mssql_cfg['user'], $mssql_cfg['pass']) or die("<font color='red' style='font-size:12px;font-weight:bold;'>Disconnect to MS-SQL Server!!</font>");
    Return $conn;
}
?>