PHP - Moved: Connection From Php To Sql Server 2005 Database Using Sqlsrv_connect()

I've been working on this for 8 hours and still cannot get sqlsrv_connect to work. Thank you, Microsoft. My connection strings work for Access DBs and MySQL - but I can't get this to work.

For servername, I've tried:
$serverName = "MYSERVER";
$serverName = "(MYSERVER\MYINSTANCE)";
$serverName = "'MYSERVER\MYINSTANCE'";
$serverName = "(MYSERVER)";

Setup:
PHP Compiler = MSVC9 (Visual C++ 2008)
C:\Program Files (x86)\PHP\v5.3\php.ini
extension_dir C:\Program Files (x86)\PHP\v5.3\ext\
php_sqlsrv_53_nts_vc9.dll in the extension library.

And I'm getting an error from sqlsrv_errors, so it looks like the DLL is working. Pulling my hair out here.

Any ideas?

Code: [Select]
$serverName = "MYSERVER\MYINSTANCE";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"$dbname");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if($conn) {
echo "Connection established.\n";
} else {
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}

sqlsrv_close( $conn);


Connection could not be established. Array ( => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53].  => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. ) [1] => Array ( => HYT00  => HYT00 [1] => 0  => 0 [2] => [SQL Server Native Client 10.0]Login timeout expired  => [SQL Server Native Client 10.0]Login timeout expired ) [2] => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

Hi friends...
I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working.
I google it and found some solutions but not successsful yet.
Can anyone give me detailed guide (step by step) that how i can connect PHP with Sql Server 2005???
Thanks in advance...

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=353212.0

Most of the time my localhost works like a champ but occasionally I  get  ... mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'localhost' (11001)

On phpfreaks I've searched for "Unknown MySQL server host localhost " and didn't see an answer to this problem

Then I googled and found this http://stackoverflow...-localhost11001

However in this file the localhost ip is commented out and windows wont let me edit the file to uncomment it like it's done in the stackflow post.   So, one is this the likely problem ... and if it is how do I edit a file in the Windows folder?   As a note I do go into the file as the administrator using notepad   Thanks
Edited by floridaflatlander, 03 June 2014 - 08:21 AM.

after cloasing connection of database i still got the values form database.

Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
if(!$result){
echo "cont fetch data";

}else{

   $row= mysql_fetch_array($result);
   echo "id".$row[0]."usrname".$row[1]."passwped".$row[2]."date".$row[3]."time".$row[4];
}
//  echo "<html>";
//echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
//      echo "<thead>";
//           echo"<tr>";
//                   echo "<th>";
//                   echo ID;
//                   echo"</th>";
//                   echo" <th>";echo Username; echo"</th>";
//                    echo"<th>";echo Password; echo"</th>";
//                    echo"<th>";echo Last_logged_date; echo "</th>";
//                   echo "<th>";echo Last_logged_time;  echo "</th>";
//               echo" </tr>";
//           echo" </thead>";
//           echo" <tbody>";
//while($row= mysql_fetch_array($result,MYSQL_BOTH)){
//             echo "<tr>";
//              echo "<td>";
//              echo $row[0];
//               echo "</td>";
//                   echo "<td>";
//              echo $row[1];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[2];
//               echo "</td>";
//                   echo "<td>";
//                echo $row[3];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[4];
//               echo "</td>";
//            echo "</tr>";
//     }
//         echo" </tbody>";
//         echo "</table>";
//         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values from doatabase session is destroyed".$_SESSION['admin'];
?>

session is destroyed but database connection is not closed.

thanks