CODEWITHSUNDEEP
phpsql-serverdll
Kingsley
Kingsley

Reputation: 404

About PHP and Microsoft SQL Server

My system is Win7-32bit and i'm using Apache 2.4.2 and with PHP 5.4.4 by XAMPP win32-1.8.0-VC9-installer.

Recently i'm building a website for my friend's online server, and he's using Microsoft SQL Server Express 2005. I've searching many solutions about the sqlsrv.dll extension on the internet, unfortunately is it doesn't slove my problem. I had extracted the php_sqlsrv.dll extension into php/ext/ folder, and added extension=php_sqlsrv.dll in php.ini config file, but i still got the WARNING error (PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv.dll' - The specified module could not be found.) during restarting the Apache service.

Because there's too many download links on the internet and i really don't understand about the non-thread-safe and thread-safe for extensions, so for pros please give the direct links to download those extensions file which is matched with my PHP and MS SQL Server versions.

Required Extensions: - sqlsrv.dll - pdo_sqlsrv.dll

Of course, if there are any i need to pay attention or modify, please give your advice.

Your help would be greatly appreciated!

Upvotes: 1

Views: 2785

Answers (1)

nwalke
nwalke

Reputation: 3209

You'll want the "SQLSRV30.EXE" from this page. You'll need to check whether you're running thread-safe or not (use phpinfo();). The naming of the files that come out of that exe are important. You want the ones with "54" in the name. Then the "TS" or "NTS" refers to thread-safe or non-thread-safe. For more information refer to the manual.

Upvotes: 2

Related Questions