Welcome Guest, Not a member yet? Register   Sign In
Codeigniter + odbc mssql + remote server
#1

[eluser]misteryosox44[/eluser]
Can anyone help me about this problem. I am using codeigniter framework to connect to mssql 2008 server using odbc connection. It works perfectly on my local connecting a database on a live server. But when I test it to a live domain, it will only shows a white screen for a sample select statement. Heres my database.php.

Code:
$db['default']['hostname'] = 'Driver={SQL Server};Server=ip_of_server;Database=dbname;';
$db['default']['username'] = 'sa';
$db['default']['password'] = 'password';
$db['default']['database'] = 'dbname';
$db['default']['dbdriver'] = 'odbc';
$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'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;


and heres my select statement
Code:
$res = $this->db->get("room");
echo "<pre>";
print_r($res->result_array());
echo "</pre>";

Is there any configurations I need to made in my cpanel of the webhost. Or anything, any help please. Thanks.




Theme © iAndrew 2016 - Forum software by © MyBB