PHP PDO Driver not found

Asked Jun 27 '18 at 08:41

Active Jun 27 '18 at 14:13

Viewed 703 times

I have issues with my PHP installation under Ubuntu 16.04 LTS. I am getting the error: the driver is not found 1. I already tried the fix from the following post: PDOException “could not find driver” but it doesn't work. I am running Apache2 with a PHP7.2 Installation. If I run phpinfo() I can see, that it's
"PHP Version 7.2.7-1+ubuntu16.04.1+deb.sury.org+1"
and I can see the PDO extension and the pdo_mysql extension, so theoretically it should find the driver. Both states enabled.

The Script im calling:

<?php
include("sqlconnection.php");
$statement = $pdo->prepare("SELECT * FROM reaktor WHERE reactorID = 1");
$result = $statement->execute();
$return = $statement->fetchAll();
echo json_encode($return);
?>

The sqlconnection.php:

<?php
  $serverName = "nw-system.de";
  $dbName = "openComputers";
  $username = "";
  $passwort = "";
  try{
    $pdo = new PDO("sqlsrv:server=$serverName ; Database=$dbName", $username, $passwort);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  }
  catch(Exception $e)
  {
    exit(print_r($e->getMessage()));
  }
?>

I have deleted the username and password on purpouse

Any Ideas on how to fix this?
Kind regards
Jan

edited Jun 27 '18 at 14:13

asked Jun 27 '18 at 08:41

`sudo apt-get install php7.2-mysql` and `sudo phpenmod pdo_mysql` after that restart your apache. – jagad89 Jun 27 '18 at 08:50
@jagad89 - The OP states _"If I run phpinfo() ... I can see the PDO extension and the pdo_mysql extension"_ – M. Eriksson Jun 27 '18 at 08:51
Tried that already – Jun 27 '18 at 08:51
@MagnusEriksson Oh!! My bad – jagad89 Jun 27 '18 at 08:51
can you see those extensions in `php -m` output too? – jagad89 Jun 27 '18 at 08:52
When do you get the error message? Are you running your script through Apache or CLI? – M. Eriksson Jun 27 '18 at 08:52
@jagad88 Yes I can – Jun 27 '18 at 08:54
@Magnus Eriksson Calling a PHP Script via Ajax – Jun 27 '18 at 08:55
I do have it installed – Jun 27 '18 at 08:59
Then I have no idea, unless the ajax request is calling some other URL on another server/setup. These things are pretty hard to debug from a distance... – M. Eriksson Jun 27 '18 at 09:05
@JanKrüger update your question with PHP source code. – jagad89 Jun 27 '18 at 09:47
@jagad89 I updated it. – Jun 28 '18 at 06:49
your connection string starts with `sqlsrv`, are you using MSSQL? if yes, read [this](https://www.reich-consulting.net/support/developement/php-developement/install-php-sqlsrv-driver-on-linux/). if you using MySQL change it to `mysql:`. – jagad89 Jun 28 '18 at 07:50
Yes that was it. Im using MySQL. I ripped that code out of another project that is using MsSQL. What a foolish mistake. Thx for the help. – Jun 28 '18 at 07:56
Dangerous copy paste. Stay alert!! happy coding :) – jagad89 Jun 28 '18 at 07:59

PHP PDO Driver not found

0 Answers0