[Dbix-class] Can't get MSSQL connected

[Peter Rabbitson]

Oleg Kostyuk wrote:
> 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.
> 

This is odd... pop into #dbix-class poke me (ribasushi) for help.