Fatal error: Call to undefined function sqlsrv_connect()

Question

I have come across quite a few post regarding the same subject question, however I am still unable to resolve it and so I ask. I am trying to connect to sql in my php script. My connection string is:

/* Specify the server and connection string attributes. */
$serverName = "xxx-PC\SQLExpress";
$connectionOptions = array("Database"=>"Salesforce");
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn === false)
{
      die(print_r(sqlsrv_errors(), true));
}

I have installed and included the following in my php.ini file located under the wamp folder: C:\wamp\bin\php\php5.4.16:

extension=c:/wamp/bin/php/php5.4.16/ext/php_sqlsrv_53_ts.dll

My wampserver is running fine and so are the wampapache and wampsqld services. I am able to execute php.exe successfully. However I am unable to make the connection to SQL Server 2008 R2 where my database is located. Please help!

EDIT 1: The wamp server is running the wampmysql service while I am trying to connect to SQL Server 2008 R2. Could this be the reason? Should I be using MySQL instead of SQL? Any pointers?

EDIT 2: I do not see sqlsrv section at all when I run phpinfo() though I have added extension=php_sqlsrv_54_ts.dll in the php.ini file located in the bin folder of the wamp server.

enter image description here

To avoid red herrings: MySQL and SQL Server are completely different database engines—the code you've posted does not use neither PDO nor MySQL. — Álvaro González
@ÁlvaroG.Vicario I removed the PDO dll and updated the path to the extensions added so as to make sure it refers the dll in the php/ext folder. However, my phpinfo() return no sqlsrv section. Any pointers? — Sarah

Álvaro González Álvaro González · Accepted Answer · 2014-02-26T11:32:12

When you install third-party extensions you need to make sure that all the compilation parameters match:

PHP version
Architecture (32/64 bits)
Compiler (VC9, VC10, VC11...)
Thread safety

Common glitches includes:

Editing the wrong php.ini file (that's typical with bundles); the right path is shown in phpinfo().
Forgetting to restart Apache.
Not being able to see the startup errors; those should show up in Apache logs, but you can also use the command line to diagnose it, e.g.:
```
php -d display_startup_errors=1 -d error_reporting=-1 -d display_errors -c "C:\Path\To\php.ini" -m
```

If everything's right you should see sqlsrv in the command output and/or phpinfo() (depending on what SAPI you're configuring):

[PHP Modules]
bcmath
calendar
Core
[...]
SPL
sqlsrv
standard
[...]

Fatal error: Call to undefined function sqlsrv_connect()

5 Answers