Sorry to be so vague in my least plea. I really am stumped with this and
need the help, so here is more info in case you need it.
I use the following line to set up my Catalyst web app using DBIC on
Windows XP
script\omtsweb_create.pl model DB DBIC::Schema WebApp::Schema
create=static components=TimeStamp,EncodedColumn dbi:ODBC:webapp test01
mypass
This gives me a whole slew of errors, all similair to this one:
DBIx::Class::Schema::Loader::make_schema_at(): syscolumns has no primary
key at C:/Perl/site/lib/Catalyst/Helper/Model/DBIC/Schema.pm line 173
I know what the "no primary key" error is, but since the only tables it
complains about are the System Tables, I don't want to mess with them.
I don't want it to read those system tables into my schema at all, but
it creates a .pm file for every table including the system tables.
In SQL Server 2005 and 2008 the System Tables have been removed and
replaced with Views. This whole thing works properly in those versions,
but the older version of SQL Server 2000 causes the problem.
Is there some easy way around this? I would rather not have to tell the
boss to upgrade the database if I don't have to.
Thanks for your help.
Ascii King wrote:
I am getting an error about the System Tables in MS SQL server 2000
not having key fields. Is there something special I need to do to get
the DBIX::Class to work with SQL Server 2000?
It works fine on SQL Server 2008, which doesn't have System tables.
_______________________________________________
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]
_______________________________________________
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]
