[eluser]woodydude[/eluser]
Hi,
I'm having a similar issue with MSSQL however it doesn't matter if I'm using Active Record or not. (tbh I'd prefer working with MySQL but the current website's written using this DB and I'm slowly migrating the site over to PHP
)
The erroneous response I'm getting is:
Quote:A Database Error Occurred
Error Number:
SELECT * FROM Dir_Location
The code I'm having an issue with is:
Code:
$query = $this->db->query('SELECT * FROM Dir_Location');
return $query->result_array();
My db connection settings are:
Code:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "user1";
$db['default']['password'] = "mypassword";
$db['default']['database'] = "intranet";
$db['default']['dbdriver'] = "mssql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "Latin1_General_CI_AS";
I've tried putting the table name in [] brackets which doesn't seem to help in any way, I've read through all the links on this thread however any pointers in the right direction would be greatly received.