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 connecting to the MSSQL database. I can connect to the MSSQL database using: 'tsql -S MyServer -U MyUsername -P MyPassword' and execute queries just fine I can also connect to and query the database in Perl using: 'my $dbh = DBI->connect("dbi:Sybase:MyServer", 'MyUsername', 'MyPassword');' However, when trying to create a Catalyst Model, I get: 'perl script/MyApp_create.pl model MyModel DBIC::Schema MyApp::SchemaClass create=static dbi:Sybase:MyServer MyUser MyPassword' 'DBIx::Class::Schema::Loader::make_schema_at(): DBI Exception: DBD::Sybase::st execute failed: Server message number=208 severity=16 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' Does anyone have any idea what's going on, and how I can get this working? I'm relatively new to Catalyst, but not Perl. I've created a few simple Catalyst apps using MySQL and never had a problem with DBIx::Class::Schema::Loader, but it would be really helpful if I could begin creating Catalyst apps with our MSSQL database. Thanks for any help. - Meeko
_______________________________________________ List: Catalyst@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/