[Dbix-class] Can't get MSSQL connected

[Oleg Kostyuk]

Hello guys,

Please help.
I have catalyst app + dbic schema, all working fine with sqlite.
I'm trying to change dsn and connect to mssql, and can't get it working.
username/pass is correct - I checked via rdp connection with native
mssql server console.
All needed things is installed as described inDBIx::Class::Storage:
:DBI::ODBC::Microsoft_SQL_Server.
What could be problem?....

DBIC version is 0.08127

Connection config:

<Model::DB::HeadOffice>
    <connect_info>
        # SQLite working just fine
        # dsn         dbi:SQLite:__path_to(tmp/herbal-headoffice.sqlite.db)__
        dsn
dbi:ODBC:server=192.168.0.102;driver=FreeTDS;tds_version=8.0;database=headoffice
        user        sa
        password    qqqqq
    </connect_info>
</Model::DB::HeadOffice>

Please see http://paste.scsys.co.uk/85491 for server log messages.

Thanks in advance!

-- 
Sincerely yours,
Oleg Kostyuk (CUB-UANIC)