I am getting error:
ADONewConnection: Unable to load database driver ''
Fatal error: Call to a member function SetFetchMode() on a non-object in C:\inetpub\wwwroot\fannie\src\SQLManager.php on line 75
SQLManager.php
@class SQLManager
@brief A SQL abstraction layer
Custom SQL abstraction based on ADOdb.
Provides some limited functionality for queries
across two servers that are useful for lane-server
communication
*/
$QUERY_LOG = $FANNIE_ROOT."logs/queries.log";
if (!function_exists("ADONewConnection")) include($FANNIE_ROOT.'adodb5/adodb.inc.php');
class SQLManager {
/** Array of connections **/
var $connections;
/** Default database connection */
var $default_db;
/** Constructor
@param $server Database server host
@param $type Database type. Most supported are
'mysql' and 'mssql' but anything ADOdb supports
will kind of work
@param $database Database name
@param $username Database username
@param $password Database password
@param $persistent Make persistent connection.
*/
function SQLManager($server,$type,$database,$username,$password='',$persistent=False){
$this->connections=array();
$this->default_db = $database;
$this->add_connection($server,$type,$database,$username,$password,$persistent);
}
/** Add another connection
@param $server Database server host
@param $type Database type. Most supported are
'mysql' and 'mssql' but anything ADOdb supports
will kind of work
@param $database Database name
@param $username Database username
@param $password Database password
@param $persistent Make persistent connection.
When dealing with multiple connections, user the
database name to distinguish which is to be used
*/
function add_connection($server,$type,$database,$username,$password='',$persistent=False){
$conn = ADONewConnection($type);
$conn->SetFetchMode(ADODB_FETCH_BOTH); <<<<<----------------------------------------******LINE 75******--------------------------------------------------------------
$ok = False;
if (isset($this->connections[$database])){
$ok = $conn->NConnect($server,$username,$password,$database);
}
else {
if ($persistent)
$ok = $conn->PConnect($server,$username,$password,$database);
else
$ok = $conn->Connect($server,$username,$password,$database);
}
$this->connections[$database] = $conn;
if (!$ok){
$conn = ADONewConnection($type);
$conn->SetFetchMode(ADODB_FETCH_BOTH);
$ok = $conn->Connect($server,$username,$password);
if ($ok){
$stillok = $conn->Execute("CREATE DATABASE $database");
if (!$stillok){
$this->connections[$database] = False;
return False;
}
$conn->Execute("USE $database");
$this->connections[$database] = $conn;
}
else {
$this->connections[$database] = False;
return False;
}
}
return True;
}
/**
Close a database connection
@param $which_connection
If there are multiple connections, this is
the database name for the connection you want to close
*/
function close($which_connection=''){
if ($which_connection == '')
$which_connection=$this->default_db;
$con = $this->connections[$which_connection];
unset($this->connections[$which_connection]);
return $con->Close();
}
/**
Execute a query
@param $query_text The query
@param which_connection see method close
@return A result object on success, False on failure
*/
