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)
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]