Configuring PHP 5.3 to work with MS SQL Server

Question

I've been tasked with taking all of our MySQL databases and migrating them to SQL Server. In attempting to get PHP 5.3.24 to work with MSSQL, I've done the following:

Copied the non thread-safe drivers to /php/ext.

Updated my php.ini file to include the following two lines:

extension=php_pdo_sqlsrv_53_nts_vc9.dll;
extension=php_sqlsrv_53_nts_vc9.dll

Restarted IIS 7 running on Windows Server 2008 R2.

phpinfo shows sqlsrv under Registered PHP Streams, and sqlsrv also appears under PDO drivers and pdo_sqlsrv support shows as "enabled." Yet, when I try to connect via my application, I get the following:

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in C:\inetpub\wwwroot\mystuff\myphpconnectfile.php

My connect string looks like this:

$con = new PDO("mssql:host=xxx.xxx.xxx.xxx,1433;dbname=mydb", "user", "pwd");
$con -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return($con);

Looks like it's finding the server okay, but not the PHP/PDO mssql drivers. What have I missed?

EDIT: Configure Command under phpinfo shows the lines "--without-mssql" "--without-pdo-mssql". I don't know where to go to change this, or if it's necessary.

Why on earth does one want to migrate from MySQL to MS-SQL?!? — arkascha
– arkascha, Commented Nov 18, 2013 at 12:20
Try new PDO('sqlsrv: ... '); instead of new PDO('mssql: ... '); — ɴᴀᴛᴇ ᴅᴇᴠ
– ɴᴀᴛᴇ ᴅᴇᴠ, Commented Nov 18, 2013 at 12:21
@arkascha: Believe me, it was not my idea, and I fought it. We're getting along fantastically with MySQL, but TPTB have decided that, for interoperability, everything needs to be in SQL Server. Lucky me. — Chris
– Chris, Commented Nov 18, 2013 at 12:22
@FDL: That got me somewhere. I'm now getting this error: An invalid keyword 'host' was specified in the DSN string. Do I need to rewrite my connection string? — Chris
– Chris, Commented Nov 18, 2013 at 12:24

ɴᴀᴛᴇ ᴅᴇᴠ · Accepted Answer · 2013-11-18 12:28:29Z

3

You're using an invalid DSN connection string for MSSQL. You need to use the format found here.

new PDO('sqlsrv:Server=xxx.xxx.xxx.xxx,1433;Database=mydb', 'user', 'pwd');

answered Nov 18, 2013 at 12:28

ɴᴀᴛᴇ ᴅᴇᴠ

4,6316 gold badges40 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Configuring PHP 5.3 to work with MS SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related