Apache Friends Support Forum

I noticed that someone else had issues with getting XAMPP to work with MS-SQL Server 2005 (http://community.apachefriends.org/f/viewtopic.php?f=16&t=49124). I followed that thread with interest, as I'm unable to get XAMPP to work with my MS-SQL Server 2008 R2, even after I followed the same instructions.

As of right now, I do not have the code set up to give me a specific reason for the error; just a simple JavaScript alert saying whether it works or not.

Here is the code that is not working. Any suggestions would be greatly appreciated.

Code: Select all

      $conn = mssql_connect( 'STONEHENGE\MSSQLSERVER', 'username', 'password');
      if( $conn ) {
          $statusMsg= "Database connection works.";
      }else{
          $statusMsg= "Database connection is NOT working.";
      }

Thanks,

^_^

Has anyone experienced the same issue with M$ SQL Server 2008 R2?

^_^

I finally got it working.

First, I downloaded the SQL Server 2008 R2 Drivers for PHP located here. I followed the instructions to extract the files directly into my /xampp/php/ext folder, and modified my php.ini file to include the extension I needed.

Then I modified my code as follows, using sqlsrv_connect, instead of mssql_connect:

Code: Select all

$sName = "MYSERVER,1433\MYINSTANCE"; //I include the port after a comma in the server name.
$cInfo = array("Database"=>"FirstTest", "UID"=>"myUser", "PWD"=>"myPassword");
$conn = sqlsrv_connect($sName, $cInfo);
if($conn) {
    $notNice = "Database connection works."; // If $notNice exists, I use JavaScript to show an alert.
    sqlsrv_close($conn);
}else{
    $notNice = "Database connection is NOT working.";
    die(print_r(sqlsrv_errors(), true));
}


And it now works. :) This can be marked SOLVED. I looked for a way to do it, myself, and can't find it.

^_^

Thanks for your feedback and I am sure your posts will help others with a similar problem.

Best wishes.