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