Error odbc_connect() SQL Error - Can't Open lib 'SQL Server'

Issue

Ketika hendak membuka koneksi ke database Microsoft SQL Server dengan PHP muncul error seperti berikut.

PHP Warning:  odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found, SQL state 01000 in SQLConnect in 
/home/user/public_html/tes.php on line 8

Hal tersebut kemungkinan karena driver belum ada sehingga perlu diinstall terlebih dahulu.

Solution

Login ke server sebagai root user.

Jika memakai Cloudlinux/CageFS, Install driver dengan perintah

/opt/alt/alt-php-config/install_odbc

Lalu update CageFS

cagefsctl --force-update && cagefsctl -M

Jika memakai RHEL/CentOS Anda dapat mengeksekusi script berikut.

#!/bin/sh

# add repo conf
#curl https://packages.microsoft.com/config/rhel/${dist_ver}/prod.repo > /etc/yum.repos.d/mssql-release.repo
cat << EOF > /etc/yum.repos.d/mssql-release.repo
[packages-microsoft-com-prod]
name=packages-microsoft-com-prod
baseurl=https://packages.microsoft.com/rhel/\$releasever/prod/
enabled=1
gpgcheck=1
gpgkey=https://packages.microsoft.com/keys/microsoft.asc
EOF

# install packages
ACCEPT_EULA=Y yum -y install msodbcsql17