Uncaught Error: Call to undefined function sqlsrv_connect() in XAMPP

Question

I am trying to connect to a SQL Server with PHP, but unfortunately it fails with calling the function at self. I installed the drivers (DLL), as well a the driver from this site: https://www.microsoft.com/de-ch/download/details.aspx?id=36434

I am receiving the following message:

Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in ....

I running a local server with XAMPP with the newest PHP version 7.1.1.

UPDATE:

I checked if the extension is loaded in PHP:

var_dump(extension_loaded ("php_sqlsrv_7_nts"));

But it gives me a bool(false) back.

Yes thats what I meant.... this will help u there was a smilar problem : stackoverflow.com/questions/30736601/… — Masivuye Cokile
– Masivuye Cokile, Commented Mar 14, 2017 at 9:00
Are you using sqlsrv 4.0 (downloaded from Microsoft's website)? If so, see my answer here — ImClarky
– ImClarky, Commented Mar 14, 2017 at 11:21
@ImClarky Yes I downloaded the 4.0 version. Now I also downgraded to php version 7.0 but it doesn't work as well. I don't have any idea why I get this error. — Julian
– Julian, Commented Mar 14, 2017 at 11:24

René Höhle · Accepted Answer · 2017-03-14 08:58:12Z

0

You have to install the MSSQL extension first and enable them. The is not working out of the box. What you have in your example is the ODBC driver but you need the PHP Extension in No Thread Safe Mode for your PHP-Version.

It's a bit complicated to find the correct extensions. Otherwise you can try to connect over ODBC but that make all a bit more complicated.

Try this:

https://learninglaravel.net/microsoft-drivers-for-php-7-for-sql-server-is-now-available

edited Mar 14, 2017 at 8:58

answered Mar 14, 2017 at 8:52

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

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

2 Comments

Julian Over a year ago

Thanks for your answer, but I already done this. I added it to the ext folder and registered it in the php.ini file.

René Höhle Over a year ago

Can you check if the Extension is loaded? It's possible that there are differents to PHP 7.1 and it's not working. And be sure that you use the Not Thread Safe version sorry my fault.

Collectives™ on Stack Overflow

Uncaught Error: Call to undefined function sqlsrv_connect() in XAMPP

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related