Cannot Call function sqlsrv_connect()

Question

I went through several questions and recommendation to resolve the above issue, but No luck at all.

I have the following settings:

Windows Server 2008 R2

xampp-win32-1.8.2-5-VC9-installer

SQLSRV30 - php driver

sqlncli - Microsoft SQL Server 2008 R2 Native Client Set Up

I installed everything else and I have the following on the php.ini file The code below show where the php drivers are residing:

; On windows:
extension_dir="C:\xampp\php\ext"

enter image description here The following is under windows extensions

extension=php_pdo_sqlsrv_54_ts.dll
extension=php_sqlsrv_54_ts.dll

enter image description here

When I check the phpinfo file sqlsrv is not listed. I know this may imply that its not installed, but It is installed.

The following is the php info file:

I also restarted apache and the server. Am I missing something ?

I get the following error:

Call to undefined function sqlsrv_connect()

This the code I am using to connect: I am connecting to another server which is hosting SQL Server 2005

/Connection to SQL Server Database
    error_reporting(E_ALL);
$serverName = "172.xx.x.xxx";

$connectionInfo = array('Database'=>'Eque', "UID"=>"develop", "PWD"=>"develop");
$conn = sqlsrv_connect($serverName, $connectionInfo);


if($conn) {
     echo "Connection established.<br />";
}else {
    echo  "Connection could not be established.<br />";
    die(print_r(sqlsrv_errors(), true));
}

did you enabled those modules in php.ini file. If it is not there please add it and restart the server — Sundar
– Sundar, Commented Jul 16, 2014 at 8:50
Yes, @Sundar I un-commented the modules on the php.ini file by removing ; — kya
– kya, Commented Jul 16, 2014 at 8:54
after enabling the ini settings don't forget to restart the apache server — Sundar
– Sundar, Commented Jul 16, 2014 at 9:04

Isaac Gachugu · Accepted Answer · 2014-11-08 10:18:59Z

8

I have struggled through the process and this is what has finally worked. I am using php 5.4.16 and Apache 2.4.4 with Sql Express 2008 R2.

Download Microsoft Drivers for PHP for SQL Server from Microsoft download site
Extact the files to a local folder
Copy php_sqlsrv_54_ts.dll and php_pdo_sqlsrv_54_ts.dll to the Ext folder (C:\wamp\bin\php\php5.4.16\ext). You can confirm the folder by checking the value of extension_dir in php.ini file stored under Apache (C:\wamp\bin\apache\Apache2.4.4\bin).
Add extension for the two drivers by adding these lines: extension=php_sqlsrv_54_ts.dll extension=php_pdo_sqlsrv_54_ts.dll and comment out the existing lines below if not commented: ;extension=php_pdo_mssql.dll ;extension=php_mssql.dll
Start all Wamp services

answered Nov 8, 2014 at 10:18

Isaac Gachugu

1491 silver badge5 bronze badges

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

Comments

Sundar · Accepted Answer · 2014-07-16 08:54:31Z

4

Load the PHP drivers in php.ini file and restart the server.

extension=php_sqlsrv_53_ts.dll
extension=php_pdo_sqlsrv_53_ts.dll

Reference: http://technet.microsoft.com/en-us/library/cc296203(v=sql.105).aspx

TS denotes thread safe. find your server is thread safe or non thread safe

answered Jul 16, 2014 at 8:54

Sundar

4,6506 gold badges40 silver badges63 bronze badges

13 Comments

kya Over a year ago

I am using php 5.4.27. isn't the drivers you are recommending for php 5.3 ?. I attached the phpinfo file for more details

Sundar Over a year ago

This should work. Still they not released 5.4 anyway check it up again in the drivers folder.. what you pasted in the ext folder. if you 54 use that or use 53. 53 will work i used it before

Sundar Over a year ago

use this function to test your loaded extensions php.net/manual/en/function.extension-loaded.php

kya Over a year ago

Still no luck. Its not part of the loaded extensions

kya Over a year ago

I am considering installing sqlexpress locally to test it. I will post any changes after installation.

|

Stefan Michev · Accepted Answer · 2016-05-04 23:25:44Z

0

What worked for me on windows 10 64bit and php 5.6. is the 3.2 version of the driver downloaded from here:Microsoft SQL Server driver for PHP

answered May 4, 2016 at 23:25

Stefan Michev

5,1034 gold badges37 silver badges30 bronze badges

Collectives™ on Stack Overflow

Cannot Call function sqlsrv_connect()

3 Answers 3

Comments

13 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

13 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related