SQL Server Native Client Connection?

[eluser]Tamilmani[/eluser]
Hi All,

i am able to connect the SQL Server Native Client. By using below code

Code:

$active_group = "default";
$active_record = TRUE;

$db['default']['hostname'] = "Driver={SQL Server Native Client 10.0};Server=ipaddress;Database=databasename;";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "databasename";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

If i am used above code . My below query is not working .How i fix this issue . Any Suggestion Please
Example code

Code:

$query = $this->db->get_where('table', array('username' => $username, 'password' => $password));
        if ($query->num_rows() == 0)
        {
            return "";
        }
        else
        {
            $row = $query->row();
            return $row->user_id;
        }

I am try to login in my application , but unfortunately i am getting some error

Code:

Fatal error: Call to undefined method Users::_remove_invisible_characters() in C:\wamp\www\project\database\drivers\odbc\odbc_driver.php on line 248

Thanks
Tamilmani Mohan

[eluser]CI_adis[/eluser]
Hi, i do not know ho to help you, i hope that you find a solution untill now.
But just wanted to thank you! You helped me with my connection problem using CI for days now!

Thanks again!