Welcome Guest, Not a member yet? Register   Sign In
Database connectivity error
#1

[eluser]bhakti.thakkar[/eluser]
Hi all,
i am using mssql as my DB and all is fine. but at times i see this error :


Code:
A Database Error Occurred
Unable to select the specified database: MyDB


I am unable to figure it out why is this connectivity problem occuring. Below is my code in config/database.php:

Code:
$active_group = "default";
$active_record = TRUE;

$db['default']['hostname'] = "IPDAADRESS : 4233";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "DBName";
$db['default']['dbdriver'] = "mssql";
$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";

i refresh the page multiple times and things work. what could be the problem.

Please help me

Thanks in anticipation
#2

[eluser]bhakti.thakkar[/eluser]
Hi all,
Still some times getting this error. Is CI configuration not supporting MSSQL DB?

i am using freetds to connect from my Linux box




Theme © iAndrew 2016 - Forum software by © MyBB