无法连接到Microsoft SQL Server

Question

I'm trying to connect a php script to a Microsoft SQL Server, Additionally I'm doing some testing on my own to learn more about php and servers.

if(function_exists("sqlsrv_connect"))
{
    echo "exists<br/>";
}else
{
    die("does not exist<br/>");
}
$serverName = "myTestServer";
$connectionInfo = array( "Database"=>"test_name", "UID"=>"testUser", "PWD"=>"testPwd");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn)
{
    echo "sucessful";
}
else
{
    echo "failed ";
}

The output is:

exists
failed

Therefore I can see that the .dll was installed as intended. Am I missing something else? or could this be a problem in the server properties?

Answer 1

Whenever a failure occurs with a SQLSRV PHP function, call sqlsrv_errors to find out the root cause. In your case, it seems you don't have the correct SQL Server ODBC drivers installed on the PHP server. Install the drivers as recommended by your error message, and things should improve.