macOS Ventura (Apple Silicon M2) + XAMPP + PDO SQL SERVER: PDO Exception - Could not find driver
I hope you guys are doing well.
I used for many years Windows Server + XAMPP for php development, specifically, using the SQL Server Database.
Recently, I chanced to a brand new MacBook Pro M2, which is my first experience using macOS.
Right now, I am struggling to make my installation detect the pdo_sqlsrv driver. The phpinfo file doesn't show the sql driver listed. Besides, all the connection attempts shows PDO exception: Could not find driver.
I followed the instructions listed on the following article: https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16
php -v command returns:
PHP 8.1.12 (cli) (built: Oct 30 2022 12:39:49) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.12, Copyright (c) Zend Technologies with Zend OPcache v8.1.12, Copyright (c), by Zend Technologies
sudo CXXFLAGS="-I/opt/homebrew/opt/unixodbc/include/" LDFLAGS="-L/opt/homebrew/lib/" pecl install sqlsrv shows:
pecl/sqlsrv is already installed and is the same as the released version 5.10.1 install failed
And I also used the sudo CXXFLAGS="-I/opt/homebrew/opt/unixodbc/include/" LDFLAGS="-L/opt/homebrew/lib/" pecl install pdo_sqlsrv command:
pecl/pdo_sqlsrv is already installed and is the same as the released version 5.10.1 install failed
I added the following lines inside the /Application/XAMPP/etc/httpd.conf file:
<FilesMatch .php$>
SetHandler application/x-httpd-php
</FilesMatch>
Inside manager-osx, the server events tab isn't show any kind of error or warning. Do you guys have any idea of what am I missing, or doing wrong?
I was able to finish the installation using the following link: https://github.com/microsoft/msphpsql/blob/master/Linux-mac-install.md#installing-the-drivers-on-macos