How to connect to mssql using pdo through PHP and Linux?

Question

I'm trying to for a new PDO connection using the following code.

new PDO("mssql:driver=????;Server={$serverName};Database={$databaseName}", $username, $password, array(PDO::ATTR_PERSISTENT => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

I'm not sure what drivers to use? Or how to install them. I can connect perfectly fine using the mssql_connect function in PHP but I want to use the PDO library instead.

My php.ini settings for mssql are:

ssql

MSSQL Support   enabled
Active Persistent Links     0
Active Links    1
Library version     FreeTDS

Directive   Local Value Master Value
mssql.allow_persistent  On  On
mssql.batchsize 0   0
mssql.charset   no value    no value
mssql.compatability_mode    Off Off
mssql.connect_timeout   5   5
mssql.datetimeconvert   On  On
mssql.max_links Unlimited   Unlimited
mssql.max_persistent    Unlimited   Unlimited
mssql.max_procs Unlimited   Unlimited
mssql.min_error_severity    10  10
mssql.min_message_severity  10  10
mssql.secure_connection Off Off
mssql.textlimit Server default  Server default
mssql.textsize  Server default  Server default
mssql.timeout   60  60

Michael Irigoyen · Accepted Answer · 2013-09-04 18:02:45Z

30

The PDO mssql driver is no more, use sqlsrv (under php windows) or dblib (under php linux)

http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx

http://www.php.net/manual/en/ref.pdo-dblib.php

edited Sep 4, 2013 at 18:02

Michael Irigoyen

23.1k18 gold badges92 silver badges132 bronze badges

answered May 11, 2011 at 14:01

James

22.4k5 gold badges29 silver badges44 bronze badges

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

8 Comments

richie Over a year ago

using dblib still produces the missing drivers error. "Uncaught exception 'PDOException' with message 'could not find driver'". I find it strange that mssql_connect works fine yet I have to do something in order to get the PDO side working. I'm not very familiar with linux which means that I'm unsure of getting the drivers that I need sorted out?

James Over a year ago

You need to enable pdo_dblib.so in your php.ini and set up FreeTDS under Linux.

shorif2000 Over a year ago

how do you enable pdo_dblib in configure? also I am using centos 5 32bit, how would I set it up?

Dominick Over a year ago

pdo_dblib no longer works with PHP 5.4+... I can't find a suitable solution to this problem.

Honinbo Shusaku Over a year ago

@James Is the PHP Microsoft PDO_SQLSRV deprecated or is there no problems using it?

|

Karl Wilbur · Accepted Answer · 2015-05-31 22:59:27Z

5

I am running Ubuntu 14.04. Trying to connect to MSSQL I got "Uncaught exception 'PDOException' with message 'could not find driver'". It seems that I was missing the dblib/sybase PHP extension.

I had to run:

sudo apt-get install php5-sybase freetds-common libsybdb5 \ 
&& sudo apache2ctl restart

Works fine now.

edited May 31, 2015 at 22:59

answered Jan 14, 2015 at 3:23

Karl Wilbur

6,3473 gold badges47 silver badges57 bronze badges

1 Comment

Jefferson Lima Over a year ago

The php-sybase package solved the problem for me. I didn't need to install the others.

csi · Accepted Answer · 2011-05-10 17:28:17Z

1

Try

$dbh = new PDO ("mssql:host=$hostname;dbname=$dbname","$username","$pw");

$hostname may need to be configured as either...
$hostname.':'.$port;

OR

$hostname.','.$port;

answered May 10, 2011 at 17:28

csi

9,3689 gold badges64 silver badges81 bronze badges

1 Comment

richie Over a year ago

The error message that I get is Uncaught exception 'PDOException' with message 'could not find driver'

Shivashish · Accepted Answer · 2018-11-01 05:25:45Z

0

The dblib/sybase PHP extension tip posted by Karl Wilbur worked for me. The pre-installation check page for LimeSurvey now shows

PHP PDO driver library- Microsoft SQL Server (dblib), MySQL

Just make sure you find and install the version that aligns with the PHP version you are using;

Prompt>sudo apt-get install php<appropriate version>-sybase freetds-common libsybdb5 Prompt>sudo apache2ctl restart

Cheers,

edited Nov 1, 2018 at 5:25

answered Nov 1, 2018 at 5:17

Shivashish

11 bronze badge

Collectives™ on Stack Overflow

How to connect to mssql using pdo through PHP and Linux?

4 Answers 4

8 Comments

1 Comment

1 Comment

PHP PDO driver library- Microsoft SQL Server (dblib), MySQL

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

1 Comment

1 Comment

PHP PDO driver library- Microsoft SQL Server (dblib), MySQL

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related