odbc connection to a remote system

[eluser]Waiel[/eluser]
No i'm setting this inside the controller
as i'm going to have to connect to multiple servers at the same time

the main database is Mysql set in the database.php

here is the full controler file user.php

Code:

class Users extends Controller {

    function Users()
    {
        parent::Controller();    
    }
    
    function index()
    {

                $dbs['hostname'] = '192.168.1.3';
                $dbs['username'] = '';
                $dbs['password'] = '';
                $dbs['database'] = 'qwin_5501q';
                $dbs['dbdriver'] = 'odbc';
                $dbs['dbprefix'] = '';
                $dbs['pconnect'] = True;
                $dbs['db_debug'] = FALSE;
                $dbs['cache_on'] = FALSE;
                $dbs['cachedir'] = "";
                $dbs['char_set'] = "utf8";
                $dbs['dbcollat'] = "utf8_general_ci";
                $dbs['port']= 8888;
                $msdb=$this->load->database($dbs,TRUE);
        
                $mr = $msdb->query("select * from STAFINFO");
                foreach ($mr->result() as $row ){
        
                    echo $row->Name;
                    echo "<br />";
                }
        }
}

it's just a test to see if it's going to connect