odbc connection to a remote system

[eluser]Henry Weismann[/eluser]
Thats wierd...did you change the db config array like so:

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;

The array is now named db not dbs and it is multidimensional. If you did it does not matter because the way you did it by passing the config parameters is fine. Just try this after you connect:

Code:

echo "Database Resource: ".$msdb."<br />";
$mr = $msdb->query("select * from STAFINFO");
$result = $mr->result_array()
echo "Database Result as Array: ".print_r($result);