[eluser]veamon[/eluser]
Does anyone have an idea of how to connect to sql server 2000, either with an ODBC or using the mssql driver? CI only seems to show an example of mysql, I would hope they would have examples for all. I tried just using 'mssql' as my driver, and it wont connect. I can make an odbc connection, so I know my user/pass etc is right.
Here is my connection file:
$db['default']['hostname'] ="gissv4";
$db['default']['username'] = "ubdl_user";
$db['default']['password'] = "Ubdl1!";
$db['default']['database'] = "UBDL";
$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";
I DID use an ODBC, and it connected, but i get errors trying to get records, and from what I've found, ODBC is crap with CI.
