Welcome Guest, Not a member yet? Register   Sign In
resolving config issues
#1

[eluser]archon[/eluser]
on my prod server I can connect to a ms sql database like so
Code:
$this->con = odbc_connect('al-barran', 'a_user', 'a_password') or die(odbc_errormsg());

I can perform queries normally thur this functionality. If I read the documentation/reviewing the code... ci should be able to perform this type of connection if I can get my settings correct.

So in my ci database config I have
Code:
$db['default']['db_debug'] = TRUE;
$db['default']['hostname'] = "";
$db['default']['username'] = "a_user";
// the password provided has a $ so changed double to single
$db['default']['password'] = 'a_password';
$db['default']['database'] = "al-barran";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

added the following to my controller
Code:
ini_set('display_errors', 'On');
error_reporting(-1);
define('MP_DB_DEBUG', true);

Unfortunately I am still getting the generic 'A Database Error Occurred'. Any advice would be appreciated. Either for displaying what is wrong or point out where I have err'd in my config.


Messages In This Thread
resolving config issues - by El Forum - 08-20-2012, 08:41 PM
resolving config issues - by El Forum - 08-21-2012, 06:35 AM
resolving config issues - by El Forum - 08-21-2012, 07:20 AM
resolving config issues - by El Forum - 08-21-2012, 08:51 AM



Theme © iAndrew 2016 - Forum software by © MyBB