Welcome Guest, Not a member yet? Register   Sign In
Connect to SQL SERVER 2008 R2
#1

[eluser]Unknown[/eluser]
I have a problem in connecting in SQL SErver..
It appear white screen everytime I'm using mssql driver and it seems an error..

Here is my set-up:

$db['default']['hostname'] = 'JDICEN-PC';
$db['default']['username'] = 'sa';
$db['default']['password'] = 'xxxxxxx';
$db['default']['database'] = 'COBS_BIDDING';
$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;

Can anyone help me to solve my problem...
#2

[eluser]mobs6[/eluser]
Please Read This Forum Thread, try to put the DB Port in your config database:

http://ellislab.com/forums/viewthread/213879/
#3

[eluser]sdclee[/eluser]
What I am looking for here is a definitive answer as to the requirement to switch from a mysql to an mssql driver in CI 2.x
Is it the case that apart from the change in database.php it is necessary to have a php configured with php_mssql.dll ?
TIA
#4

[eluser]sdclee[/eluser]
Ok I have it working now and am pleased to announce it is very straightforward when you know the requirement (php_mssql.dll and the right database.php)!
On the shared hosting IIS7 Server 2008, CI 2.x it barfs at the standard database.php where there is no closing php markup. All I needed to change apart from that was the following:

$db['default']['hostname'] = "mssql.mydatabase.host";
$db['default']['username'] = "foobar_1";
$db['default']['password'] = "CrypticPassword";
$db['default']['database'] = "foobar_1";
$db['default']['dbdriver'] = "mssql"




Theme © iAndrew 2016 - Forum software by © MyBB