On Sat, Nov 14, 2009 at 12:49 PM, Alan Humphrey <[email protected]> wrote: > Just upgraded to 0.08113 and ran a small test script against a MSSQL 2005 > database. Connection is made via FreeTDS. Here's the error. Relevant > lines of the program below. > > DBIx::Class::ResultSet::next(): Unable to estable connection to determine > database type: DBIx::Class::ResultSet::next(): DBI Exception: > DBD::Sybase::db do failed: Server message number=195 severity=15 state=5 > line=1 server=SQLA4 text='CHAINED' is not a recognized option. [for > Statement "SET CHAINED OFF"] at test.pl line 26 > > > my $schema = > BirdWeb::BirdWebSchema->connect('DBI:Sybase:server=SNAME;database=DBNAME','L > OGIN','PASSWORD',{disable_sth_caching=>1}); > > > my $result = $schema->resultset('SurveyorsSurveySites')->search({}, > {join => 'surveyor', > order_by => ['surveyor.name'], > page => 5 > }); > > > while (my $row = $result->next() ){ > say $row->name . "\t" . $row->surveysites->first()->year; > } > > > http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf > 5350e/SSMASybase.docx has this: > > SET CHAINED > Issue > SQL Server 2005 does not support SET CHAINED. > > SSMA support > Yes > > Solution > Change SET CHAINED to SET IMPLICIT_TRANSACTIONS. > > > > - Alan > > > > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/[email protected] >
Does this happen consistently? I had this issue and it just went away after a bunch of tries, so debugging this got impossible. -- fREW Schmidt http://blog.afoolishmanifesto.com _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
