Specified driver could not be loaded due to system error 127 (SQL Server Native Client 10.0).

Question

My configuration is:
PHP 5.3
SQL Server 2005 Express
SQL Server Driver for PHP 1.1
Microsoft SQL Server 2008's SQL Server Native Client

When I run the sql server connection function in php, i get the following error message:
"Specified driver could not be loaded due to system error 127 (SQL Server Native Client 10.0)."

SQLSTATE: IM003
Code: 160

How can i fix this error?

Answer 1

The SQL Server Driver for PHP 1.1 requires the SQL Server 2008 Native Client, which must be downloaded and installed before the PHP driver will work.  See this page for the feature pack. Locate the SQL Server 2008 Native Client section and download the msi for your platform.

Install the msi and the message should no longer appear.  You can verify the proper ODBC driver is installed by locating the SQL Server Native Client 10.0 in the Drivers tab of the ODBC Data Sources control panel.

Please follow up if you have further problems.

Jay

---

Jay Kint MSFT

Answer 2

As mentioned in my configuration I've installed Microsoft SQL Server 2008's SQL Server Native Client

When I look in the Drivers tab of my ODBC Data Sources I find:
SQL Server Native Client 10.0 Version: 2007.100.2531.00

Any other suggestions?

Roy

Answer 3

Please post your connection string options, and we’ll investigate further.

Thank you,

Serban

---

Serban Iliescu - MSFT

Answer 4

I use the following connection function:

public function connection() {
    	$connectionInfo = array (
 		'Database' => dbname,
		'UID' => dbusername,
    		'PWD' => dbpassword   	
    	);
    	$this->db_link = sqlsrv_connect(dbhostname,$connectionInfo);
		if (!$this->db_link){
			die( print_r( sqlsrv_errors(), true));
		}
		
    }

Hope this will help

Answer 5

I've tried reinstalling SQL Server 2005 Express and reinstalling the Microsoft SQL Server 2008's SQL Server Native Client.

Still the same error!

Phpinfo() tells me that the sqlsrv library is loaded succesfully...

My operating system is Windows Server 2000 Service Pack 4

Any other suggestions?

Answer 6

I don't see anything amiss in the information provided so far.  Can you write a small script and run it from the command line and connect to the database?

Jay

---

Jay Kint MSFT

Answer 7

I'm having the exact same problem trying to use 1.1 and went back to 1.0.  I noticed the system requirements in the help file no longer list Windows 2000 Server SP4.  Maybe 2000 Server is no longer supported in 1.1?