Jump to content


Photo

PEAR::MDB2 Connection Problem


  • Please log in to reply
No replies to this topic

#1 mohnerplex

mohnerplex
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 05 July 2006 - 05:26 PM

Hello, I am attempting to use the PEAR::MDB2 package.  I have installed the MDB2 package (MDB2-2[1].1.0.tgz) and the MSSQL Driver (MDB2_Driver_mssql-1[1].1.0.tgz).  I execute the following code:

<?php
    require_once('MDB2.php');
    echo "THIS IS A SQL SERVER DATABASE TEST<BR>";

    $dsn = 'mssql://login:password@192.168.1.15/mydb';
 
    echo "CREATING INSTANCE<BR>";
    $mdb2 =& MDB2::factory($dsn);
    if (PEAR::isError($mdb2)) {
        echo "INSTANCE FAILED<BR>";
        die($mdb2->getMessage());
    }
    else
        echo "INSTANCE SUCCESSFUL<BR>";

    $query = 'SELECT * FROM Contact';
    echo "ATTEMPTING QUERY<BR>";
    $result =& $mdb2->query($query);  //execution stops here!
    // check if the query was executed properly
  if (PEAR::isError($result)) {
        echo "QUERY FAILED";
        die($result->getMessage());
    }
    else
        echo "QUERY SUCCESSFUL";
       
    $mdb2->disconnect();
?>

The output on screen is:

THIS IS A SQL SERVER DATABASE TEST
CREATING INSTANCE
INSTANCE SUCCESSFUL
ATTEMPTING QUERY

So execution is stopping at the indicated line, but I am not sure why I am not getting any errors returned.  Any help would be much appreciated.  Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users