how to add extension sqlsrv & pdo_sqlsrv to php (nginx)

aaP_tony

This sort of work, you need to enable microsoft's repo first otherwise you won't be able to install msodbcsql. For CentOS7 it is:

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

And after you are done, you will have to use PDO instead of sqlsrv to connect.

aaP_andresberry01

aaPanel_Jose
While following your instruction, I got this error:

configure: error: invalid variable name: `'

How to fix this?

aaPanel_Kern

aaP_andresberry01
Hello, please take a screenshot or provide more details.

aaP_andresberry01

aaPanel_Kern
Look like this..

aaPanel_Kern

aaP_andresberry01
Replace it with this: there is an extra space above
./configure --with-php-config=/www/server/php/80/bin/php-config

aaP_andresberry01

aaPanel_Kern
It works... Thank you 😄

Ultraman

Found working tutorial https://idnetter.com/cara-install-extension-sqlsrv-dan-pdo_sqlsrv-php-7-4-di-aapanel/

Bumb1ebe

Ultraman Hey, i am getting this error https://prnt.sc/nTp4vp-K0SzL . Could you help me please?

Ultraman

you may have missed a step in the tutorial Bumb1ebe. So, reinstall PHP and try again to follow the tutorial.

aaP_webat66013

Please share steps for how to add sqlsrv or mssql extension add in php7.0 version.

OS:- 20.04.4 LTS (Focal Fossa)
aaPanelLinux panel used.

poetra4522

what extension should I install?
Thanks

aaPanel_Kern

Hello, please install the extension according to your website program

poetra4522

aaP_lightningmu.services

Just remember the extension 5.3.0 is OLD, for PHP new, you need use : 5.11.0 or 5.12.0
The step is the same in case of manually install, but you can install on the aaPanel UI, is very simple.

Go to:

App Store
Installed apps
Select (Context option on your PHP version)
And install the extensions by the UI.