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/[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]
_______________________________________________
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]
