Connect to SQL SERVER 2008 R2 |
[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...
[eluser]mobs6[/eluser]
Please Read This Forum Thread, try to put the DB Port in your config database: http://ellislab.com/forums/viewthread/213879/
[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
[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" |
Welcome Guest, Not a member yet? Register Sign In |