I'm trying to connect to my SQL Server database hosted on a Linux VM. I'm running xampp on my development windows machine, and the connection is from a php site I'm building. I think I need to usesqlsrvto connect. I downloaded the dll sql-server-ver15&viewFallbackFrom=sql-server-2019## from https://learn.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view= #

I have moved the necessary dll files to my

xamppphpetcdirectory. I also verified that the extension directory in the php.ini file isextension_dir="C:xamppphpext"

The following has been added to the

Dynamic Extensionssection of php.ini:

extension=php_sqlsrv_81_ts_x86.dll extension=php_pdo_sqlsrv_81_ts_x86.dll extension=php8ts.dll

I found information online about removing the

php_prefix, removing the.dllsuffix, using ts or not ts, moving all files to the extension directory, only the ones listed above Several files were moved to the directory information, excludingphp8ts. dlletc. I have tried every configuration above, both logical and illogical.

This is the sample connection code for my website:

$conn = new PDO('sqlsrv:Server=my_server_ip\MSSQLSERVER;Database=dbname', 'username', 'password'); if ($conn === false) { echo "Error (sqlsrv_connect): ".print_r(sqlsrv_errors(), true); exit; } else { echo "success"; }

I tried multiple different connection examples. By doing the above, I get this error:

Fatal Error: Uncaught PDOException: Driver not found in C:xampphtdocssiteindex.php:123 Stack trace: #0 C:xampphtdocssiteindex.php(123): PDO ->__construct('sqlsrv:Server= my_server_ip', 'username', 'password') #1 {main} throws in C:xampphtdocssiteindex.php on line 123

From here I logically thought okay, let's check by echoing

phpinfo();. There is nothing listed forsqlsrvor PDO variants anywhere in the list. Even if you ctrl f on the sqlsrv page, you can only find the above error.

I have verified that the ODBC driver is installed.

Other things I've tried is using

sqlsrv_connectinstead of PDO. I found conflicting information regarding my php version (8.1) but thought I'd give it a try anyway. However, when I encounter that variant I get:

Fatal error: Calling undefined function sqlsrv_connect()

To me it's obvious that my .dll isn't being recognized or something like that. Yet for the life of me I can't understand why. I've verified everything is running as administrator, restarted xampp multiple times, deleted/redownloaded the dlls, etc.

Can anyone point out any obvious issues that I might not have thought of?

extension=php_sqlsrv_81_ts_x64.dll extension=php_pdo_sqlsrv_81_ts_x64.dll extension=php8ts.dll extension=php_pdo_odbc.dll extension=php_pdo.dll