Conexão adodb com SQL Server

From: Date: Tue, 01 Apr 2014 12:07:35 +0000
Subject: Conexão adodb com SQL Server
Groups: php.general 
Request: Send a blank email to php-general+get-323126@lists.php.net to get a copy of this message
Guys, I'm trying to make the connection to the SQL Server database using adodb, but when I run the lines below, the page is blank, not returning any rows. The problem from what I dectetei, is when the connection attempt is made ​​with the server and the table data.  Thank you in advance. <?php // Include the library include('adodb/adodb.inc.php'); $conn = &ADONewConnection('mssql'); $conn->Connect('192.168.1.2:1433','','','siscom'); // Connection to the database $sql = "SELECT * FROM agenda"; // Select the table columns calendar $consulta = $conn->Execute($sql); // Displaying Data echo("<table width='250' border='1'>         <tr>             <td>ID</td>             <td>Name</td>         </tr>"); while(!$query->EOF) {     echo("<tr>             <td>" . $query->fields[0] . "</td>             <td>" . $query->fields[1] . "</td>           </tr>");     $query->MoveNext();  } // Number of table records  $tot_register = $consulta->RecordCount(); echo("<tr><td colspan='2'> Total record (s): " . $tot_register . "</td></tr>"); echo("</table>");

« previous php.general (#323126) next »