How to configure the sqlsrv driver in windows for php

Question

Warning: PHP Startup: Unable to load dynamic library 'sqlsrv_74_ts_x64' (tried: C:\php\ext\sqlsrv_74_ts_x64 (The specified module could not be found), C:\php\ext\php_sqlsrv_74_ts_x64.dll (The specified module could not be found)) in Unknown on line 0

I have done all proper configurations like:
Downloading the php sql drivers from the official microsoft website
extracting the version i need to C:\php\ext\ folder eg php_pdo_sqlsrv_74_ts_x64.dll
added the extension=php_pdo_sqlsrv_74_ts_x64.dll

My php version is 8.2.3

Answer 1

Hi @Mohammed Hussein,

Please refer to this link:

https://learn.microsoft.com/en-us/iis/application-frameworks/install-and-configure-php-on-iis/install-the-sql-server-driver-for-php

I'm not familiar with PHP. So I can only answer your question from the SQL Server perspective.

Check that the required dependencies are installed. The sqlsrv driver has several dependencies that need to be installed on your system, including the Microsoft ODBC Driver for SQL Server, the Microsoft Command Line Utilities 15 for SQL Server, and the Visual C++ Redistributable for Visual Studio 2019.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".