Welcome Guest, Not a member yet? Register   Sign In
Connection issues with MSSQL and IIS
#2

[eluser]trahma[/eluser]
I did some more testing and put this file in my root directory of code igniter:

Code:
database tester<br /><br />
&lt;?
  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));
    }
?&gt;

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.


Messages In This Thread
Connection issues with MSSQL and IIS - by El Forum - 07-17-2007, 09:48 AM
Connection issues with MSSQL and IIS - by El Forum - 07-17-2007, 10:17 AM
Connection issues with MSSQL and IIS - by El Forum - 07-17-2007, 11:01 AM
Connection issues with MSSQL and IIS - by El Forum - 07-17-2007, 11:08 AM



Theme © iAndrew 2016 - Forum software by © MyBB