Re: Conexão adodb com SQL Server

On 04/01/2014 09:10 AM, Mauricio Tavares wrote:

On Tue, Apr 1, 2014 at 11:28 AM, Jim Lucas <lists@cmsws.com> wrote:

On 04/01/2014 05:07 AM, Edson David wrote:

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

As the other Jim said, enable error reporting and display_errors and you might get something. Be warned, if it a parse error that is causing this issue, you will need to enable the above two settings in your php.ini file instead of placing those options in your script. What I do sometimes when doing the above it too much hassle is to remove the all but the first line, then add back each line. Always keep an echo '!done!'; at the end to make sure that the script is finishing. My guess is

       I myself am not a great php programmer, so I try to use the "or

die()" thingie (kinda like try/except in python?) so I know a given statement worked or went boink. For instance, if it did not connect to the database, why continue?

This method does work with 99% of all problems. But, if you have a parse error, it will not work. Parse errors are a fatal error. It can't even complete parsing your script, so it never fires that "or die();" call.

going to be that it is something in your include'd file or the adonewconnection() function call.

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>");

-- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/