Welcome Guest, Not a member yet? Register   Sign In
Am having a problem connecting to mssql

When i change the driver in the database.php, the login page comes as a blank page.
Can anyone pliz what i should do to handle this error.

i am having same problem it displays only a blank page. i am using mssql 2008. and codeigniter 2.1.0. here i can access to mssql by hard coding it works fine, the problem is only with codeigniter. i have tried by removing @ in the driver as well, it is same only blank page. can any one please help me.......

my settings as follows:

$db['default']['hostname'] = "NEEROZE-PC";
$db['default']['username'] = 'sa';
$db['default']['password'] = 'root';
$db['default']['database'] = 'cbas';
$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';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

thanks in advance

"Make sure that you are loading the correct php extensions for the driver you’re trying to use (php_mssql, php_sqlsrv, etc) and check to see if errors are being suppressed using @ in the driver connection function."

check that in you php install on the server you have the php_mssql extension installed ( phpinfo() ).

then check your apache error log for any errors, if you can post that it will help


Your host name is probably not correct.

Here is the typical format for mssql

$db['ideal']['hostname'] = 'computer_name\sql_instance';
$db['ideal']['username'] = 'username';
$db['ideal']['password'] = 'password';
$db['ideal']['database'] = 'database';
$db['ideal']['dbdriver'] = 'mssql';

Host name must be either computer name \ sql instance to work. Or have an alias set up on your server so that it will do that for you.

default sqlexpress I beleive is SQLEXPRESS I changed mine so I can't give the default to by looking up my install.

Theme © iAndrew 2016 - Forum software by © MyBB