Jump to content

mohnerplex

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

mohnerplex's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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);  [b]//execution stops here![/b]     // 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!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.