PHP SQL Server driver
Ir para navegação
Ir para pesquisar
Sobre
Olá! Visitante, reunimos aqui, informações sobre como instalar o PHP SQL Server driver (PDO_SQLSRV).
Requisitos
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