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

[Matt Whipple]

Ascii King wrote:
> 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.
>
If you're not going to use them then just remove the classes for them.

> 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
>>
>
> _______________________________________________
> 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