[eluser]trahma[/eluser]
I did some more testing and put this file in my root directory of code igniter:
Code:
database tester<br /><br />
<?
include('system/application/config/database.php');
echo "php is working<br /><br />";
$c = mssql_connect($db['default']['hostname'], $db['default']['username'], $db['default']['password']) or die('ROO - Error: Could not connect to database. Please contact your Systems Administrator!');
mssql_select_db($db['default']['database'],$c);
$results=mssql_query('SELECT * FROM states',$c);
echo "MSSQL rows returned: ".mssql_num_rows($results)."<br />";
if($myrow=mssql_fetch_row($results))
{
do {
echo 'Shortname: '.$myrow[1].'<br />';
} while($myrow=mssql_fetch_row($results));
}
?>
This code seems to run fine without errors which leads me to believe there's a CI issue somewhere. I'm running SQL2000 as well, I'm assuming that's supported fine since PHP doesn't have a problem with it.