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: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 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! Quote Link to comment https://forums.phpfreaks.com/topic/13756-pearmdb2-connection-problem/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.