[Catalyst] Creating Catalyst Models from MSSQL

[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=3Dstatic 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 using freetds.  It's kind of a PITA to have to manually create
all my schemas, but at least it works.

- Meeko


On Tue, Aug 4, 2009 at 4:00 AM, <kmx at volny.cz> wrote:

> Hi,
>
> > state=3D1 line=3D1 server=3DMyServer text=3DInvalid object name
> > 'sysrowsetcolumns'.
> > [for Statement "SELECT * FROM sysrowsetcolumns WHERE ( 1 =3D 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 hidden
> and cannot be queried like "SELECT * FROM sysrowsetcolumns". The reported
> error is probably an issue somewhere in DBIx::Class::Schema::Loader
> (but they are not claiming to support MSSQL - unfortunately).
>
> > 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.
> DBD::ODBC is a pretty good option that I would recommend if you are on
> a Win32 system. I am afraid you will not be able to use DBD::ODBC for
> MSSQL connection from a UNIX system.
>
> --
> kmx
>
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20090804/ee278=
375/attachment.htm