Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs

Question

I am using

Xampp version 3.2.1 with PHP version 5.6.8.
Microsoft Azure SQL server

GOAL

I am trying to create a web app that will access to my database, and be able to SELECT, INSERT, UPDATE and DELETE records.

PROBLEM

I cannot connect to the database server

ERROR

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\BLT\Employee_Database .php on line 25

CODE

<html>
<head>
    <Title>Employee Database</Title>
</head>
<body>
<form method="post" action="?action=add" enctype="multipart/form-data">
    Last name <input type="text" name="LastName" id="LastName"/></br>
    First name <input type="text" name="FirstName" id="FirstNamne"/></br>
    E-mail address <input type="text" name="Email" id="Email"/></br>
    User Id <input type="text" name="UserId" id="UserId"/></br>
    Password <input type="password" name="Password" id="Password"/></br>
    <input type="submit" name="submit" value="Submit"/>
</form>

<?php
$serverName = "jy4nij6vuy.database.windows.net,1433";
$connectionOptions = array("Database" => "robertfarb",
    "UID" => "robertFarb",
    "PWD" => "******");
$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}
?>

</body>
</html>

THIS IS WHAT I TRIED SO FAR

I have installed the Microsoft PHP for SQL drivers and followed all the instructions to load the driver, but it does not seem to be working!
I added the php_sqlsrv_56.ts.dll file to the extensions folder of PHP, and also the php_pdo_sqlsrv_56.ts.dll.
I also added the extension=php_sqlsrv_56.ts.dll line to the php.ini file.

Any help would be much appreciated!

just becdause you put a file somewhere and tell php to load it doesn't mean php can ACTUALLY load it. if the function's not defined, then you provided an invalid library (e.g. wrong version, wrong compiler) and php skips it because it's not loadable. Check the server error logs to see what happened during php startup. — Marc B
– Marc B, Commented Jun 9, 2015 at 15:38
This is the error that I found: PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv_56_ts.dll' - The specified module could not be found. — Robert Farb
– Robert Farb, Commented Jun 9, 2015 at 15:59

RubbelDieKatz · Accepted Answer · 2017-07-13 13:25:02Z

25

The MSSQL extension is not available anymore on Windows with PHP 5.3 or later. SQLSRV, an alternative driver for MS SQL is available from Microsoft: » http://www.microsoft.com/en-us/download/details.aspx?id=20098

Step by Step

Download SQLSRV32.EXE (Microsoft Drivers for PHP for SQL Server) from: http://www.microsoft.com/en-us/download/details.aspx?id=20098
Choose path: C:\xampp\php\ext

enter image description here

Uncomment or Append extension = php_sqlsrv_56_ts.dll in php.ini
Restart Apache from XAMPP Control Panel (Stop/Start)

I tested it and it works 100%

You can find the most recent compiled binaries in the official Microsoft Git repository.

edited Jul 13, 2017 at 13:25

RubbelDieKatz

1,1961 gold badge17 silver badges37 bronze badges

answered Jun 10, 2015 at 4:53

Leandro Papasidero

3,7381 gold badge20 silver badges33 bronze badges

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

4 Comments

Robert Farb Over a year ago

That's exactly what I did, and I still can't get the driver to load. Any other ideas?

Leandro Papasidero Over a year ago

Please make sure the dll file is in ext folder

Zahra Over a year ago

There is no php_sqlsrv_56_ts.dll file in ext folder.What should I do??

Mahmut Salman Over a year ago

You should downlaod it from the Microsoft website @Zahra here

Jordi · Accepted Answer · 2015-10-14 07:23:04Z

10

I followed Lea Tano guide and didn't work. I needed a fer more steps. At least for Windows7 (or for my system) there're some missing steps(ie those who don't have MSSQL Server installed in the same server/machine).

Here's how i made it work:

Follow Lea Tano guide to install SQLSRV 5.6 (or 5.3 or..)
Download and install the OBDC Driver 11 (msodbcsql.msi)
Download and install the SQL Server Native Client (sqlncli.msi file)
Check if installed (if not, download and install) Visual C++ Redistributable VS2012 Update4 (vcredist_x86.exe)

answered Oct 14, 2015 at 7:23

Jordi

6162 gold badges9 silver badges16 bronze badges

Comments

General Grievance · Accepted Answer · 2021-12-27 16:56:18Z

2

Lea's answer should do the trick for you. It is very important that you download PHP 5.6 from the Web PI - https://www.microsoft.com/web/downloads/platform.aspx

Make sure to use IE when you download the Web PI to your machine.

edited Dec 27, 2021 at 16:56

General Grievance

5,12039 gold badges40 silver badges60 bronze badges

answered Jun 10, 2015 at 16:37

meet-bhagdev

2,74820 silver badges22 bronze badges

Comments

ov_rezoy · Accepted Answer · 2021-12-29 08:05:21Z

1

Download Microsoft Drivers for PHP for SQL Server Windows (Link), It'll be a zip file after downloaded open the file
Extract the downloaded file in default PHP extension directory (Usually c:\php\ext , c:\xampp\php\ext)
To enable the SQLSRV driver, modify php.ini by adding the following line to the extension section. your PHP version and the extension/dll version should match you can refer to the below image. changing the filename as appropriate:

extension=php_sqlsrv_80_ts.dll

To enable the PDO_SQLSRV driver, the PHP Data Objects (PDO) extension must be available, either as a built-in extension or as a dynamically loaded extension.

extension=php_pdo_sqlsrv_80_ts.dll

Restart the Web server.

Please read the MS document Loading the Microsoft Drivers for PHP for SQL Server For Detailed Steps and more info

NOTE: REMEMBER TO LOAD THE DRIVER VERSION CORRESPONDING TO THE PHP VERSION REFER BELOW IMAGE

edited Dec 29, 2021 at 8:05

answered Dec 26, 2021 at 15:48

ov_rezoy

611 silver badge6 bronze badges

2 Comments

Zeitounator Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review

ov_rezoy Over a year ago

Sure, let me just edit the answer

Collectives™ on Stack Overflow

Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related