On Tue, 4 Aug 2009 12:16:36 -0400
Meeko 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 created my schema, and
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, an
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 using
use freetds.
On Tue, Aug 4, 2009 at 4:00 PM, 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
> > >
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 vie
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 server=
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
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 problem