Database Connection Accross a Network

[eluser]polaris1927[/eluser]
I have a web server box and a database server box; connection attempts to the database server from the web server generates the error message:

Code:

An Error Was Encountered
Unable to connect to your database server using the provided settings.

It works when both web and database apps are sitting on the same server box and if I attempt to connect outside of the CI framework.

Is there a config setting for network access that I am missing?

[eluser]polaris1927[/eluser]
I had configured the database class in the autoload.php file as follows:

Code:

$autoload['libraries'] = array('database');

Removing the class from the autoload.php file and attempting to connect to the database from the controller using:

Code:

function index()
{
    $conn = mssql_connect('srv03', 'pbx', 'pbx');

    mssql_select_db('BusinessDirectory', $conn);

    $r = mssql_query('Select * from Business_names', $conn);

    while ( $row = mssql_fetch_array ( $r ) )
    {
        echo $row['name'] . '<br>';
    }    

}

worked.

So, there seems to be a problem with the autoload.php and the database library?

[eluser]Pygon[/eluser]
The only real difference between your code and CI's code is that CI has rawurldecode() for the hostname and such (which shouldn't cause a problem). Ofcourse, this assumes that you have

Code:

$db['default']['dbdriver'] = "mssql";
//... AND ...//
$db['default']['pconnect'] = FALSE;

or your testing isn't very valid (since CI will try to use a persistent connection, unlike your code).

Otherwise, not sure what to say -- works perfectly fine for me using a remote MSSQL database and persistant connections.

[eluser]polaris1927[/eluser]
Thanks for the reply.

My database config is shown below:

Code:

$db['test']['hostname'] = "srv03";
$db['test']['username'] = "pbx";
$db['test']['password'] = "pbx";
$db['test']['database'] = "BusinessDirectory";
$db['test']['dbdriver'] = "mssql";
$db['test']['dbprefix'] = "";
$db['test']['pconnect'] = FALSE;
$db['test']['db_debug'] = TRUE;
$db['test']['cache_on'] = FALSE;
$db['test']['cachedir'] = "";
$db['test']['char_set'] = "utf8";
$db['test']['dbcollat'] = "utf8_general_ci";

Ruled out network connection, since I did successfully conect to the database outside of CI.

[eluser]polaris1927[/eluser]
where can I find the code that reads the autoload.php liberies list?

Also, "rawurldecode() for the hostname" where is this defined?

THX

[eluser]polaris1927[/eluser]
Found the solution!!

Code:

$db['test']['hostname'] = "srv03\phonedirec";

you need to get rid of the double quotes ("") and replace with single quotes (''), so that you now have:

Code:

$db['test']['hostname'] = 'srv03\phonedirec';

My database was configured as an instance, therefore I included a backslah when defining the ['hostname'] and this created a problem in CI.

[eluser]Pygon[/eluser]
Ahh -- yes, I didn't know you were using a "\" (the escape operator). With ""(double-quotes) you should use \\ (two backslashes) to show that you want a backslash to be output.