|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
PEAR:MDB2 NO ERRORS OUTPUT
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! |
|
#2
|
|||
|
|||
|
RE: PEAR:MDB2 NO ERRORS OUTPUT
Have you tried enabling error_reporting(E_ALL)?
If it just stops, that might be because of a fatal error. If it stops working correctly, it might be that there's something wrong in the object, and a simple print_r($object) usually points you in the right direction. |
![]() |
| Viewing: Codewalkers Forums > PHP Related > PEAR Packages > PEAR:MDB2 NO ERRORS OUTPUT |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|