Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-04 Thread kmx
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

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-04 Thread Malloy
use freetds. On Tue, Aug 4, 2009 at 4:00 PM, k...@volny.cz 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

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-04 Thread Meeko
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

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-04 Thread Stuart Watt
Amiri Barksdale wrote: 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 We use DBD::ODBC for MSSQL with little problem. The main issue was to get quoting right. We enabled portability by getting MySQL to use ANSI quotes,

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-04 Thread Lee Aylward
On Tue, 4 Aug 2009 12:16:36 -0400 Meeko meeko.li...@gmail.com wrote: 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

[Catalyst] Creating Catalyst Models from MSSQL

2009-08-03 Thread Meeko
I'm having trouble here at work creating models automatically using DBIx::Class::Schema::Loader from our MSSQL database. We use FreeTDS on Red Hat, and the MSSQL Server is Windows 2003 and SQL Server 2005. We've been using Perl for many years to create plain CGI and mod_perl apps, with no

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-03 Thread Amiri Barksdale
On Mon, Aug 03, 2009 at 03:37:37PM -0400, Meeko wrote: | We use FreeTDS on Red Hat, and the MSSQL Server is Windows 2003 and SQL | Server 2005. | |,,, | 'DBIx::Class::Schema::Loader::make_schema_at(): DBI Exception: | DBD::Sybase::st execute failed: Server message number=208 severity=16 | state=1

Re: [Catalyst] Creating Catalyst Models from MSSQL

2009-08-03 Thread Amiri Barksdale
On Mon, Aug 03, 2009 at 03:37:37PM -0400, Meeko wrote: | I'm having trouble here at work creating models automatically using | DBIx::Class::Schema::Loader from our MSSQL database. | | We use FreeTDS on Red Hat, and the MSSQL Server is Windows 2003 and SQL | Server 2005. | | state=1 line=1