Conect to Sql Server 7.0 - Error - Need Help - RESOLVED

[eluser]cwt137[/eluser]
Two thoughts:
1. Make sure that the user apache runs under can read the freetds.conf file.
2. Create a simple non-CI program to test mssql inside php. Here is an example:

Code:

// Create a link to MSSQL
$link = mssql_connect('200.200.200.50', 'sa', 'xyz');

if(!$link)
{
    die('Something went wrong while connecting to MSSQL');
}

// Select the database 'php'
mssql_select_db('db_homeshop', $link);


// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);

echo $row[0];

// Clean up
mssql_free_result($version);

If your non-CI program works, then it is a problem with CI. If your program doesn't work, then it is something to do with php.