use freetds. On Tue, Aug 4, 2009 at 4:00 PM, <[email protected]> wrote:
> Hi, > > > state=1 line=1 server=MyServer text=Invalid object name > > 'sysrowsetcolumns'. > > [for Statement "SELECT * FROM sysrowsetcolumns WHERE ( 1 = 0 )"] at > > > /usr/lib/perl5/site_perl/5.8.8/Catalyst/Helper/Model/DBIC/Schema.pm > > > line 173' > At least on MSSQL 2008 sysrowsetcolumns and some other views are hidden > and cannot be queried like "SELECT * FROM sysrowsetcolumns". The reported > error is probably an issue somewhere in DBIx::Class::Schema::Loader > (but they are not claiming to support MSSQL - unfortunately). > > > I also seem to remember reading or hearing that DBD::ODBC > > may be a better solution for MSSQL, but don't quote me on that. > DBD::ODBC is a pretty good option that I would recommend if you are on > a Win32 system. I am afraid you will not be able to use DBD::ODBC for > MSSQL connection from a UNIX system. > > -- > kmx > > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > -- Jack Malloy
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
