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 ๅๆไฝฟ็จๅ ฉ็จฎๆนๅผ。
ๆฒๆ็่จ:
ๅผต่ฒผ็่จ