exception 'com_exception' with message 'Source: Unknown

[Gramma2005]

I am trying to connect to an access db through php on Windows Server 2003 running XAMPP. The code I am using has worked before on another access db on this server so I am not sure what is causing the error. Here is my code:

# First establish the connection
$conn = new COM('ADODB.Connection') or exit('Cannot start ADO');
$result = new COM('ADODB.Recordset') or exit('Coult not make rs'); 
 
$db = 'C:\\xampp\\datasources\\ModuleDB.mdb';
 
$connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db;";    
$conn->Open($connStr);
 
if (!$conn) {
    $output .= "Connection not open";
    die();
}
 
$sql = "SELECT * FROM module";
 
$output .= "<br> SQL Statement: " . $sql;
 
####### ERROR HERE ######
$result = $conn->execute($sql);
###########################
 
$ouput .= $result;
//$result->close();
$conn->close();
 
# Clean up
$result = null;
$conn = null;  
 

The SQL statement looks find when I print it out. The full error message is:

exception 'com_exception' with message 'Source: Unknown
Description: Unknown' in C:\xampp\htdocs\mediawiki\extensions\ModuleInforma tion\ModuleInformation.php:49 Stack trace: #0 C:\xampp\htdocs\mediawiki\extensions\ModuleInforma tion\ModuleInformation.php(49): com->execute('SELECT * FROM m...') #1 C:\xampp\htdocs\mediawiki\includes\parser\Parser.p hp(3287): renderModuleInformation(NULL, Array, Object(Parser)) #2 C:\xampp\htdocs\mediawiki\includes\parser\Preproce ssor_DOM.php(982): Parser->extensionSubstitution('renderModuleInf...', Array) #3 C:\xampp\htdocs\mediawiki\includes\parser\Parser.p hp(2678): PPFrame_DOM->expand(Array, Object(PPFrame_DOM)) #4 C:\xampp\htdocs\mediawiki\includes\parser\Parser.p hp(966): Parser->replaceVariables(Object(PPNode_DOM), 0) #5 C:\xampp\htdocs\mediawiki\includes\parser\Parser.p hp(321): Parser->internalParse('parse('getPreviewText('getPreviewT ext() #9 C:\xampp\htdocs\mediawiki\includes\EditPage.php(48 4): EditPage->showEditForm() #10 C:\xampp\htdocs\mediawiki\includes\EditPage.php(34 9): EditPage->edit() #11 C:\xampp\htdocs\mediawiki\extensions\FCKeditor\FCK editor.body.php(202): EditPage->submit() #12 C:\xampp\htdocs\mediawiki\includes\Hooks.php(117): FCKeditor_MediaWiki->onCustomEditor() #13 C:\xampp\htdocs\mediawiki\includes\Wiki.php(484): wfRunHooks() #14 C:\xampp\htdocs\mediawiki\includes\Wiki.php(59): MediaWiki->performAction(Object(Article), Object(StubUser)) #15 C:\xampp\htdocs\mediawiki\index.php(93): MediaWiki->initialize(Array, Array) #16 {main}

All other posts I have seen have a better error message than 'Unknown', so I am kind of stumped. Thanks for the help!

[Gramma2005]

Not really a solution to the problem but I did find an alternative.

I set up a datasource for the database and used the following PHP code, and it works.

$conn = odbc_connect('Modules','','');
$name = $argv["modulename"];
$sql = "SELECT * FROM module WHERE module_name='" . $name . "'";
 
$rs = odbc_exec($conn, $sql);
 
# Get the fields from this database
while (odbc_fetch_row($rs)) {
 ...
}
 
odbc_close($conn);
 

Some instructions for setting up datasource can be found at:
http://articles.techrepublic.com.com...1-5160904.html