[eluser]bazianm[/eluser]
Just a few more thoughts on this:
1) Since this is SQL Server, I think I should show you the config so here it is:
Code:
$db['barcode']['hostname'] = 'DATASERV';
$db['barcode']['username'] = 'sa';
$db['barcode']['password'] = '**********';
$db['barcode']['database'] = 'BARCODE';
$db['barcode']['dbdriver'] = 'sqlsrv';
$db['barcode']['dbprefix'] = '';
$db['barcode']['pconnect'] = FALSE;
$db['barcode']['db_debug'] = TRUE;
$db['barcode']['cache_on'] = FALSE;
$db['barcode']['cachedir'] = '';
$db['barcode']['char_set'] = 'utf8';
$db['barcode']['dbcollat'] = 'utf8_general_ci';
$db['barcode']['swap_pre'] = '';
$db['barcode']['autoinit'] = TRUE;
$db['barcode']['stricton'] = FALSE;
2) On a hunch, I loaded the database class in the autoload (which loads the OTHER database, this database is for reference only). The name of the otherdatabase is INVENTORY. Now, when I run the query, it tells me that there are zero queries were queried against the INVENTORY database (this is SQL Server too).
So, I changed the default database ($active_group) to barcode and ran the query through $this->db. The query now shows up in the profiler but I STILL have no results...
As before, any suggestions welcome...