Install/enable php8.1's sqlsrv and pdo_sqlsrv drivers on ubuntu20.0-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Install/enable php8.1's sqlsrv and pdo_sqlsrv drivers on ubuntu20.0

P粉501683874 2023-11-01 11:06:13

725

I'm trying to enable the sqlsrv driver for php8.1 on Ubuntu 20.0. It doesn't show the extension inphpinfo().

When trying to check the sqlsrv module using the commandphp -m, the output is as follows:

I followed the following official documentation:

https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16
Try to add extensions in /etc/php/8.1/apache2/php.ini (extension=pdo_sqlsrv.so,extension=sqlsrv.so)

I'm not sure what's going wrong, any suggestions would be appreciated.

The output of phpinfo() for php7.4:

The output of phpinfo() for php8.1:

The thing is like this:

I have PHP 7.4 and 8.1 installed on my computer.
sqlsrv driver is suitable for php7.4 version
When trying to install/enable php8.1 it doesn't work at all.

What am I missing here?

P粉501683874

reply all (2)

P粉8232680062023-11-02 00:55:33 2 floor

I was able to solve this problem by adding the following commands.

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

You need to restart apache2 afterward

Like+0

Add Reply

P粉1933074652023-11-02 00:34:32 1 floor

You can try this:

1. switch to php8.1 2. sudo pecl uninstall -r sqlsrv 3. sudo pecl uninstall -r pdo_sqlsrv 4. sudo pecl -d php_suffix=7.2 install sqlsrv 5. sudo pecl -d php_suffix=7.2 install pdo_sqlsrv 6. sudo service apache2 restart

Please note that-r, --register-onlywill not delete the file, but will only register the package as not installed.

Check out this resource for more information.https://github.com/microsoft/msphpsql/issues/1145#issuecomment- 649682231

Like+0

Add Reply