PHP SQL Server driver

Sobre

Olá! Visitante, reunimos aqui, informações sobre como instalar o PHP SQL Server driver (PDO_SQLSRV).

Debian 8

• Microsoft ODBC Driver for SQL Server no Linux

Instalando ODBC Driver

sudo apt -y install gnupg curl
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/debian/8/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt -y update
sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sudo apt -y install unixodbc-dev

Habilitar Módulos no Apache

# PHP 7.0
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.0/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.0/mods-available/pdo_sqlsrv.ini
phpenmod -v 7.0 sqlsrv pdo_sqlsrv

# PHP 7.1
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.1/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.1/mods-available/pdo_sqlsrv.ini
phpenmod -v 7.1 sqlsrv pdo_sqlsrv

• Reiniciar o Serviço

/etc/init.d/apache2 reload

Debian 9

• Microsoft ODBC Driver for SQL Server no Linux

Instalando ODBC Driver

apt update && apt install curl apt-transport-https
curl https://packages.Microsoft.com/keys/Microsoft.asc | apt-key add -
curl https://packages.Microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list
apt update
ACCEPT_EULA=Y apt install msodbcsql17 mssql-tools unixodbc-dev php-pear php7.0-dev
pecl install sqlsrv
pecl install pdo_sqlsrv
# Se falhar a instalação por meio do repositório pecl fazer de modo manual conforme linhas comentadas abaixo:
#wget http://pecl.php.net/get/sqlsrv-5.2.0.tgz
#wget http://pecl.php.net/get/pdo_sqlsrv-5.2.0.tgz
#pecl install sqlsrv-5.2.0.tgz
#pecl install pdo_sqlsrv-5.2.0.tgz

Habilitar Módulos no Apache

cat <<EOF > /etc/php/7.0/cli/conf.d/99-sqlsrv.ini  
extension=sqlsrv.so
extension=pdo_sqlsrv.so
EOF

cat <<EOF > /etc/php/7.0/Apache2/conf.d/99-sqlsrv.ini  
extension=sqlsrv.so
extension=pdo_sqlsrv.so
EOF

• Reiniciar o Serviço

/etc/init.d/apache2 reload

Debian 10

• Microsoft ODBC Driver for SQL Server no Linux

Instalando ODBC Driver

sudo apt -y install gnupg curl
curl -s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo bash -c "curl -s https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list"
sudo apt -y update
sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
sudo apt -y install unixodbc-dev

Compilando e instalando os drivers

sudo apt -y install gcc g++ make autoconf libc-dev pkg-config
sudo apt -y install php-pear php-dev
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv

Habilitar Módulos no Apache

echo "extension=sqlsrv.so" | sudo tee /etc/php/7.3/mods-available/sqlsrv.ini
echo "extension=pdo_sqlsrv.so" | sudo tee /etc/php/7.3/mods-available/pdo_sqlsrv.ini
sudo phpenmod sqlsrv pdo_sqlsrv

• Reiniciar o Serviço

/etc/init.d/apache2 reload

Reiniciando os serviços

systemctl apache2 restart

ou

/etc/init.d/apache2 restart