[Dbix-class] SQL server 2000 giving error about System Tables

[Ascii King]

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/dbix-class@lists.scsys.co.uk
>