MSSQL ADO Connection Problems

I am connecting to the mssql database using ADOdb. It states that the connection was successful however, none of the query functions are working....

I get the following error:
[unixODBC][Driver Manager]Data source name not found, and no default driver specified

Any helped would be greatly appreciated.

Thanks



Code:


<?php

require_once('config.inc.php');
include('/usr/local/adodb/adodb.inc.php');

ADOLoadCode("ado_mssql");

$spevent = $_POST['spevent'];
echo $spevent."<br>";

$db = ADONewConnection('odbc_mssql');
$dsn = "Driver={SQL Server};Server=SPSERVER;Database=SPDATABASE";
$db->Connect($dsn,SPUSER,SPPWD);

if($db) {
echo "Connection Successful<br>";
$sql = "Select ID from tblEvent where ID = '26622'";
$rs = $db->Execute($sql);
if(!$rs){
echo "Bad<br>";
echo $db->ErrorMsg();
}
else{
echo "Good<br>";
}
}
else{
echo "Error in connection";
exit;
}
?>