Level 15
you got the ODBC Driver for your ubuntu system?
ODBC connections have never worked for me on the first try, stay strong: D
1 like
Apr 4, 2018
7
Level 1
Problems with Microsoft SQL PDO driver (PDOException)
I want to connect to a Microsoft SQL server instance that is hosted on my Windows machine from a ubuntu 16.04 virtual machine. I've installed sqlsrv and pdo_sqlsrv according to https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac
artisan migrate works, but when my application tries to access the database through the pdo driver (for example when trying to register) it throws a QueryException saying
could not find driver
The error page also shows that it is a PDOException.
How can I go about fixing this?
Level 1
Yes I installed the ODBC driver.
pdo_sqlsrv and sqlsrv don't show up in phpinfo(), but artisan can use the connection (which is defined as sqlsrv in .env)
Level 15
make a phpinfo() file, scroll down to PDO Support - PDO drivers .. does that include the proper driver?
Level 1
It only includes mysql
Level 15
but you have loaded the .so files right?
echo "extension=sqlsrv.so" >> /etc/php/7.X/apache2/php.ini
echo "extension=pdo_sqlsrv.so" >> /etc/php/7.X/apache2/php.ini
these guys, especially the pdo_* one
restart apache afterwards - afaik they should show up there
Level 53
be advised : You have 2 php.ini files, one for the command line interface and one for the webserver (probably fpm)
It might be that it is setup on the cli/php.ini but not on the fpm/php.ini
Check the output of phpinfo() to see the location of the webserver php.ini file and make sure the driver is added in there as well.
Level 1
I found a solution by posting the issue to GitHub: https://github.com/Microsoft/msphpsql/issues/736
Please or to participate in this conversation.