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

[eluser]afro[/eluser]
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.
#2

[eluser]neerose[/eluser]
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
#3

[eluser]weboap[/eluser]
"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

#4

[eluser]Matalina[/eluser]
Your host name is probably not correct.

Here is the typical format for mssql

Code:
$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