PHP unable to connect to SQL Server using PDO- exception

Question

Im trying to connect php to SQL server driver using below:

It works fine for MYSQL., but not for SQL Server.

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$data = json_decode(file_get_contents('php://input'), true);

if(!empty($data)):
header('Content-Type:text/plain');
$hostname = '10.8.8.9';                 
$username = 'siddharth';
$password = '1234';
$dbname = 'AirportFootfall';
$mssqldriver = '{SQL Server}';
//$dbh = new PDO("mssql:host=$hostname;dbname=AirportFootfall", $username, $password);
//$dbh =  new PDO("sqlsrv:Server=10.16.34.90;Database=AirportFootfall", $username, $password);
//$dbh =    new PDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=AirportFootfall", $username, $password);
//$dbh = new PDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=AirportFootfall", $username, $password);
//$dbh = new PDO("dblib:host=$hostname;dbname=AirportFootfall", $username, $password);
//$dbh = new PDO("dblib:host=$hostname;dbname=$dbname", $username, $password);
$dbh = new PDO("dblib:host=$hostname;dbname=$dbname", $username, $password);
$arraykey=array_keys($data); 
$array=$data[$arraykey[0]]; 

try 
{

    $count = $dbh->exec('INSERT INTO RadioCon_Sensor_Raw_Data(version,visitorId,dwellTime,poiId,srId,zoneId,poiProximityConfidence,zoneProximityConfidence,poiPresenceConfidence,zonePresenceConfidence,normalizedTime) VALUES ("' . implode('", "', $array) . '")' ) or die(print_r($dbh->errorInfo(), true)); 
 //echo $count;
$dbh = null;
echo 'Data Successfully inserted!!<br />';
}
catch(PDOException $e)
{
    echo $e->getMessage();
}

endif;
?>

UPDATE: Have insatalled the pdo_dblib extension.

Im getting

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /var/www/html/RADIOLOCOUS/GMR/gmrsample_copy.php:14 Stack trace: #0 PDO->__construct('odbc:Driver={SQ...', 'siddharth', '1234') #1 {main} thrown in ....line 14

Any alternate way to connect apart from pdo

Im using Ubuntu 14.04 LAMP with php 5.5

My php_info says:

PDO drivers dblib, mysql

Possible duplicate of PDO returning error "could not find driver" with a known working DSN — aynber
– aynber, Commented Mar 17, 2017 at 15:40
Enable php_pdo_mssql. stackoverflow.com/questions/11246007/… — MiltoxBeyond
– MiltoxBeyond, Commented Mar 17, 2017 at 15:40
as the exception says, you need the driver package installed on the server - another possible dublicate: stackoverflow.com/questions/5953882/… — cypherabe
– cypherabe, Commented Mar 17, 2017 at 15:43
Could you please how to install the same in UBuntu, cause im digging a lot and cannot find it to install in my Ubuntu — Sach
– Sach, Commented Mar 17, 2017 at 16:01

gus27 · Accepted Answer · 2017-03-17 17:47:16Z

1

The documentation for PDO_DBLIB shows the following DSNs:

mssql:host=localhost;dbname=testdb
dblib:host=localhost;dbname=testdb

So I'd like to suggest this:

$dbh = new PDO("dblib:host=$hostname:1433;dbname=AirportFootfall", $username, $password);

You can test your connection this way:

<?php
header('Content-Type:text/plain');
$hostname = '10.8.8.9';                 
$username = 'siddharth';
$password = '1234';
$dbname = 'AirportFootfall';
try {
    $dbh = new PDO("dblib:host=$hostname:1433;dbname=$dbname", $username, $password);

    $sql = "SELECT 'It is working' AS name";
    foreach ($dbh->query($sql) as $row) {
        print $row['name'] . "\n";
    }
} catch (PDOException $ex) {
    print $ex->getMessage();
}    
?>

edited Mar 17, 2017 at 17:47

answered Mar 17, 2017 at 16:11

gus27

2,6671 gold badge23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bhargav Rao Over a year ago

Comments are not for extended discussion; this conversation has been moved to chat.

uTombou · Accepted Answer · 2017-03-17 15:42:00Z

0

It looks like the $mssqldriver var is commented... Did you try to uncomment?? If you look carefully the Connection statement use that var:

$dbh =  new PDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=AirportFootfall", $username, $password);

answered Mar 17, 2017 at 15:42

uTombou

411 silver badge6 bronze badges

3 Comments

uTombou Over a year ago

Alse, please make sure you have installed "php5-sybase"

Sach Over a year ago

Have updated my answer @uTombou, have spending much time on this, really need to fix this...

Sach Over a year ago

Any other alternate to this fix, have updated my question with code

Collectives™ on Stack Overflow

PHP unable to connect to SQL Server using PDO- exception

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related