odbc connection to a remote system

[eluser]Henry Weismann[/eluser]
I am assuming your database either does not have a username or password or you left it out in your post for security reasons.

Try:

Code:

$db['access']['hostname'] = '192.168.1.3';
        $db['access']['username'] = '';
        $db['access']['password'] = '';
        $db['access']['database'] = 'qwin_5501q';
        $db['access']['dbdriver'] = 'odbc';
        $db['access']['dbprefix'] = '';
        $db['access']['pconnect'] = True;
        $db['access']['db_debug'] = FALSE;
        $db['access']['cache_on'] = FALSE;
        $db['access']['cachedir'] = "";
        $db['access']['char_set'] = "utf8";
        $db['access']['dbcollat'] = "utf8_general_ci";
        $db['access']['port']= 8888;
        $msdb=$this->load->database('access',TRUE);
echo "Database Resource: ".$msdb."<br />";
$mr = $msdb->query("select * from STAFINFO");
$result = $mr->result_array()
echo "Database Result as Array: ".print_r($result);