[horde] odbc help

[Garrett Davis]

I am trying to connect to a MSSQL server on Win2k.
It was suggested that I use odbc, setting up a system DSN.
But I still cannot connect to db.

I need help in setting up my auth & prefs arrays, both are
set-up now as follows.

$conf['auth']['driver'] = 'sql';
$conf['auth']['params']['phptype'] = 'odbc';
$conf['auth']['params']['hostspec'] = 'BTHwebs'; //System DSN
$conf['auth']['params']['username'] = 'horde';
$conf['auth']['params']['password'] = 'xxxxx';
$conf['auth']['params']['database'] = 'BTHwebs';
$conf['auth']['params']['table'] = 'horde_users';

Still receive error:
Sep 19  HORDE [error] [horde] FAILED LOGIN for garrett [127.0.0.1] to Horde
[on line 43 of "C:\Inetpub\wwwroot\BTHwebs\horde\login.php"]

Any help is appreciated.

-Garrett Davis