2021/12/02

Laravel Connet To MSSQL Server On CentOS

PHP ๅฎ‰่ฃ

# Install PHP 7.4
sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
sudo yum -y install https://rpms.remirepo.net/enterprise/remi-release-7.rpm
sudo yum -y install yum-utils
sudo yum-config-manager --enable remi-php74
sudo yum install -y php php-pdo php-odbc php-mbstring php-zip php-xml

MSSQL Driver ๅฎ‰่ฃ,ๆ“‡ไธ€ๅฎ‰่ฃ

1. MSSQL Driver(้ฆ–้ธ,ๆ”ฏๆด็‰ˆๆœฌ SQL Server 2000 ไปฅไธŠ)

sudo yum install php-sqlsrv
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install -y msodbcsql17

2. FreeTDS(Sql Server 2000)

sudo yum -y install php-mssql
sudo yum -y install unixODBC-*
sudo yum -y install freetds

cd /usr/lib64
sudo mv libtdsodbc.so.0.0.0 libtdsodbc.so
sudo vi /etc/odbcinst.ini

ๅœจๆœ€ๅพŒๅขžๅŠ :

[FreeTDS]
Description = ODBC for FreeTDS
Driver64    = /usr/lib64/libtdsodbc.so
Setup64     = /usr/lib64/libtdsodbc.so
FileUsage   = 1
sudo vi /etc/freetds.conf

ๅœจๆœ€ๅพŒๅขžๅŠ :

[SqlServer2000]
    host = {IP}
    port = 1433
    tds version = 8.0
    client charset = UTF-8

ๅœจ Laravel ็š„้…็ฝฎไธ€ๅˆ‡็…ง่ˆŠ,้™คไบ† MSSQL ็š„ host ่ฆๆŒ‡ๅˆฐ SqlServer2000,่‹ฅ้‡ๅˆฐๆ™‚้–“ๆ ผๅผ็š„ๅ•้กŒๅฏไปฅๅƒ่€ƒๆญค็ฏ‡,ไฝฟ็”จ FreeTDS ๅฏไปฅ้€šๅƒ,ไฝ†ๆ€•ๆœƒๆœ‰็„กๆณ•้ ๆœŸ็š„ๅ•้กŒ,ไธๅปบ่ญฐๅŒไธ€ๅฐ Server ๅŒๆ™‚ไฝฟ็”จๅ…ฉ็จฎๆ–นๅผ。

ๅƒ่€ƒ็ถฒ็ซ™

ๆฒ’ๆœ‰็•™่จ€: