[Catalyst] Creating Catalyst Models from MSSQL

[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 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'

>From the Microsoft tech docs, it appears that the 208 error comes when
you try to access a table that doesn't exist:

http://technet.microsoft.com/en-us/library/cc917588.aspx

Assuming that is not true, I found this note in DBD::Sybase:

http://search.cpan.org/~mewp/DBD-Sybase-1.09/Sybase.pm#Using_DBD::Sybase_with_MS-SQL

Amiri