[Ubuntu16.04] PHP7.4 + MSSQL2005

세팅한번 했던건데 오지게 어렵네

 

PHP버전은 7.4

 

apt-get install php-pear

 

apt-get install php7.4-dev php7.4-sybase

 

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit

sudo apt-get update

sudo ACCEPT_EULA=Y

apt-get install -y msodbcsql mssql-tools unixodbc-dev

sudo pecl install sqlsrv

sudo pecl install pdo_sqlsrv

 

echo "extension=sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

echo "extension=pdo_sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

 

 

연결 시

'hostname' => 'dblib:host=111.111.111.111:1433',