[Dbix-class] MSSQL connection error - DBIx::Class 0.08113

[Alan Humphrey]

> 
> Can you send us what happens prior to the error so we can reproduce it?
> Best
> would be if we can see all operations since $schema was instantiated
> (if
> not many)
> 

I'm not sure what you're looking for so here's a complete program and the output with DBIC_TRACE=1.

#!/usr/pkg/bin/perl -w
use strict;
use BirdWeb::BirdWebSchema;
use Modern::Perl;

my $schema = BirdWeb::BirdWebSchema->connect('DBI:Sybase:server=SERVER;database=DATABASE','LOGIN','PASSWORD',{disable_sth_caching=>1});


my $result = $schema->resultset('SurveyorsSurveySites')->search({},
    {join => 'surveyor',
     prefetch => 'surveyor',
     order_by => ['surveyor.name'],
     });


while (my $row = $result->next() ){
    say $row->surveyor->name . "\t" . $row->year;
}


Unable to estable connection to determine database type: DBI Exception: DBD::Syb
ase::db do failed: Server message number=195 severity=15 state=5 line=1 server=S
QLA4 text='CHAINED' is not a recognized option. [for Statement "SET CHAINED OFF"
] at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Schema.pm line 1027
        DBIx::Class::Schema::throw_exception('BirdWeb::BirdWebSchema=HASH(0x8232
df0)', 'DBI Exception: DBD::Sybase::db do failed: Server message numb...') calle
d at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage.pm line 123
        DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Sybase
=HASH(0x861d6b0)', 'DBI Exception: DBD::Sybase::db do failed: Server message num
b...') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI.pm l
ine 1038
        DBIx::Class::Storage::DBI::__ANON__('DBD::Sybase::db do failed: Server m
essage number=195 severity...', 'DBI::db=HASH(0x8990f20)', undef) called at /usr
/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI/Sybase.pm line 203
        DBIx::Class::Storage::DBI::Sybase::_populate_dbh('DBIx::Class::Storage::
DBI::Sybase=HASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx
/Class/Storage/DBI.pm line 851
        DBIx::Class::Storage::DBI::_get_dbh('DBIx::Class::Storage::DBI::Sybase=H
ASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storag
e/DBI/Sybase.pm line 64
        eval {...} called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Stor
age/DBI/Sybase.pm line 63
        DBIx::Class::Storage::DBI::Sybase::_rebless('DBIx::Class::Storage::DBI::
Sybase=HASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Clas
s/Storage/DBI.pm line 939
        DBIx::Class::Storage::DBI::_determine_driver('DBIx::Class::Storage::DBI:
:Sybase=HASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Cla
ss/Storage/DBI.pm line 68
        DBIx::Class::Storage::DBI::__ANON__('DBIx::Class::Storage::DBI::Sybase=H
ASH(0x861d6b0)', 'ARRAY(0x8736110)', 'ARRAY(0x890cd20)', undef, 'HASH(0x890cd40)
') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/ResultSet.pm line 66
5
        DBIx::Class::ResultSet::cursor('DBIx::Class::ResultSet=HASH(0x890cf70)')
 called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/ResultSet.pm line 954
        DBIx::Class::ResultSet::next('DBIx::Class::ResultSet=HASH(0x890cf70)') c
alled at test.pl line 16
 at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Schema.pm line 1027
        DBIx::Class::Schema::throw_exception('BirdWeb::BirdWebSchema=HASH(0x8232
df0)', 'Unable to estable connection to determine database type: DBI ...') calle
d at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage.pm line 123
        DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Sybase
=HASH(0x861d6b0)', 'Unable to estable connection to determine database type: DBI
 ...') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/Storage/DBI/Syba
se.pm line 66
        DBIx::Class::Storage::DBI::Sybase::_rebless('DBIx::Class::Storage::DBI::
Sybase=HASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Clas
s/Storage/DBI.pm line 939
        DBIx::Class::Storage::DBI::_determine_driver('DBIx::Class::Storage::DBI:
:Sybase=HASH(0x861d6b0)') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Cla
ss/Storage/DBI.pm line 68
        DBIx::Class::Storage::DBI::__ANON__('DBIx::Class::Storage::DBI::Sybase=H
ASH(0x861d6b0)', 'ARRAY(0x8736110)', 'ARRAY(0x890cd20)', undef, 'HASH(0x890cd40)
') called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/ResultSet.pm line 66
5
        DBIx::Class::ResultSet::cursor('DBIx::Class::ResultSet=HASH(0x890cf70)')
 called at /usr/pkg/lib/perl5/site_perl/5.10.0/DBIx/Class/ResultSet.pm line 954
        DBIx::Class::ResultSet::next('DBIx::Class::ResultSet=HASH(0x890cf70)') c
alled at test.pl line 16