mohnerplex Posted July 5, 2006 Share Posted July 5, 2006 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:[email protected]/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 TESTCREATING INSTANCEINSTANCE SUCCESSFULATTEMPTING QUERYSo 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! Link to comment https://forums.phpfreaks.com/topic/13756-pearmdb2-connection-problem/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.