> -----Original Message-----
> From: Oleg Kostyuk [mailto:[email protected]]
> Sent: Friday, January 28, 2011 11:37 AM
> To: DBIx::Class user and developer list
> Subject: [Dbix-class] Can't get MSSQL connected
>
> 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=h
> eadoffice
> user sa
> password qqqqq
> </connect_info>
> </Model::DB::HeadOffice>
>
> Please see http://paste.scsys.co.uk/85491 for server log messages.
>
> Thanks in advance!
>
Not sure what your specific problem is, but here's what I use to connect to
MSSQL via FreeTDS.
In my app_name.yml file:
connect_info:
dsn: 'DBI:Sybase:server=myservername;database=mydatabasename
user: username
pass: password
in my freetds.conf file:
[myservername]
host = myhost
port = 1433
tds version = 8.0
where 'myservername' in the dsn refers to the 'myservername' entry in the
freetds.conf file.
I recommend using the tsql commandline tool to make sure you've got Freetds
configured correctly, then figure out the Catalyst/DBIx::Class end of things.
- Alan
_______________________________________________
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]
