connect to mssql database via sqlsrv_connect() - PHP

Question

I'm attempting to connect to a 2005 Microsoft sql database using PHP by using the sqlsrv_connect() function. alas, the function returns false, and im not sure why.

<?php
$myServer = "MAZE.jpc.wa.edu.au.local";
$myUser = "myUsername";
$myPass = "myPassword";
$myDB = "John Paul College";
$connectionInfo = array("Database"=>$myDB, "UID" => $myUser, "PWD" => $myPass);

$conn = sqlsrv_connect($myServer, $connectionInfo); //returns false
if( $conn === false )
{
    echo "failed connection";
}

$sql = "SELECT name FROM users WHERE name= 'admin'";
$stmt = sqlsrv_query($conn,$sql);
if(sqlsrv_fetch($stmt) ===false)
{
    echo "couldn't fetch data"; 
}
$name = sqlsrv_get_field($stmt,0);
echo $name;
sqlsrv_close( $conn );
?>

Does anyone know why I can't connect? Thanks.

Edit.

Ok, well, i was able to bring up an error message thanks to the other guys answer, which states

Array (
    [0] => Array (
        [0] => IMSSP [SQLSTATE] => IMSSP
        [1] => -49 [code] => -49
        [2] => This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later)
                or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server.
                Neither of those ODBC Drivers are currently installed.
                Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver
                for x86: http://go.microsoft.com/fwlink/?LinkId=163712 
        [message] => This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) 
              or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server.
              Neither of those ODBC Drivers are currently installed. 
              Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver 
              for x86: http://go.microsoft.com/fwlink/?LinkId=163712 )
    [1] => Array (
        [0] => IM002 [SQLSTATE] => IM002 
        [1] => 0 [code] => 0 
        [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 
            [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

I'm not entirely sure how to go about fixing this issue. I'm using XAMPP as my test webserver, php version 5.3 and the following .dlls php_sqlsrv_53_ts_vc6.dll and php_pdo_sqlsrv_53_ts_vc6.dll

is your database named John Paul College? with all those spaces? then i think you should be using $myDB = "[John Paul College]"; — bansi
– bansi, Commented Dec 5, 2014 at 3:15
You need to download and install the drivers like the error message says. It pretty much explains how to solve your problem ? — Doon
– Doon, Commented Dec 5, 2014 at 3:56
doesn't it clearly stated you need SQL Server 2008 or higher? If you are still using SQL server 2005 try using mssql — bansi
– bansi, Commented Dec 5, 2014 at 3:57
Unfortunately I don't have the option of upgrading the server. I'm stuck with 2005. Does anyone know what drivers I should be using if im currently using the wrong ones? — illusion466
– illusion466, Commented Dec 5, 2014 at 4:02

Janzell Jurilla · Accepted Answer · 2014-12-05 03:26:12Z

4

I would suggest that you display the connection error using sqlsrv_errors(). Please see the following implementation.

<?php
   $serverName = "serverName\sqlexpress"; //serverName\instanceName

   // Since UID and PWD are not specified in the $connectionInfo array,
   // The connection will be attempted using Windows Authentication.
   $connectionInfo = array( "Database"=>"dbName");
   $conn = sqlsrv_connect( $serverName, $connectionInfo);

   if( $conn ) {
     echo "Connection established.<br />";
   }else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
   }
?>

For more info: http://php.net/manual/en/function.sqlsrv-connect.php

edited Dec 5, 2014 at 3:26

answered Dec 5, 2014 at 3:14

Janzell Jurilla

1,21911 silver badges17 bronze badges

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

Comments

Chillikebab · Accepted Answer · 2014-12-30 14:42:15Z

1

Download the SQL Native Client as the error message suggests. This is separate from SQL Server and a requirement for this driver to work correctly. Lesson learned from building an implementation of sqlsrv in an IIS environment

answered Dec 30, 2014 at 14:42

Chillikebab

112 bronze badges

Collectives™ on Stack Overflow

connect to mssql database via sqlsrv_connect() - PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related