Database.php settings for MSSQL database |
[eluser]JamesD[/eluser]
[quote author="cblosser" date="1197780969"]Hello, I'm a newbie to codeigniter and so far really love it. I used cakephp for a little while but was not thrilled with the documentation or lack of. I would like to use codeigniter for a project at work, but I would be required to use a MSSQL database. I searched through the forum and found lots about using ODBC, ADODB, ect, but nothing in detail as to how to format the database.php file. Here is what I have: A Microsoft SQL server running on Localhost username of "test" password of "password" database is "testdb" Below is one of the (unsuccessful) ways i've tried to configure this. $db['default']['hostname'] = "localhost:1433"; $db['default']['username'] = "test"; $db['default']['password'] = "password"; $db['default']['database'] = "testdb"; $db['default']['dbdriver'] = "mssql"; $db['default']['dbprefix'] = ""; $db['default']['active_r'] = TRUE; $db['default']['pconnect'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ""; Can someone tell me what I'm doing wrong, or give me an example of a better way? Thanks so much, Chris[/quote] Have you checked the User Guide info on database configuration? http://ellislab.com/codeigniter/user-gui...ation.html |
Messages In This Thread |
Database.php settings for MSSQL database - by El Forum - 12-15-2007, 04:56 PM
Database.php settings for MSSQL database - by El Forum - 12-15-2007, 04:58 PM
Database.php settings for MSSQL database - by El Forum - 12-15-2007, 05:13 PM
Database.php settings for MSSQL database - by El Forum - 12-15-2007, 05:34 PM
Database.php settings for MSSQL database - by El Forum - 12-15-2007, 07:17 PM
|