Hi, just to let everyone know, I never was able to get DBIx::Class::Schema::Loader to create my schemas automatically. However, I took the create=static option out, let Catalyst create just the model, and then manually created my schema, and was able to get my Catalyst app working with MSSQL using freetds. It's kind of a PITA to have to manually create all my schemas, but at least it works.
- Meeko On Tue, Aug 4, 2009 at 4:00 AM, <[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/ >
_______________________________________________ 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/
