php 7 + mssql + iis 7.5 can't connect
Good afternoon, I have already googled the entire innet, nothing helps, all hope remains for you:
PHP 7, IIS 7.5 Windows Server 2008r2 error occurs when trying to connect to MSSQL:
PHP Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in C:\inetpub\путь\connect.php:4
Stack trace:
#0 {main}
thrown in C:\путь\connect.php on line 4
In php.ini
, the extension=php_mssql.dll
directive is missing, php.ini
itself is not in this release, it was replaced with php.ini-development
and php.ini-production
The script itself:
$serverName = "mssql02\";
$connectionInfo = array( "Database"=>"", "UID"=>"", "PWD"=>"");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Соединение удалось.<br />";
}else{
echo "Соединение не удалось, ошибка:";
die( print_r( sqlsrv_errors(), true));
}
The fact that there is no server name, user, password, etc. this is not an error, just removed specifically
PDO uploaded, uploaded to ext folder:
in the php config, I added the line:
But it won't work
There are no PDO drivers at all in the phpinfo output
ODBC driver installed, this one https://www.microsoft.com/ru-ru/download/details.aspx?id=36434
1 answers
Everything was solved easier, renamed php dev. in php. ini, everything worked