[Dbix-class] DBD::Sybase - Can't call ping() with active statement handles - any ideas?

[Matt S Trout]

On Fri, Aug 22, 2008 at 01:08:33PM +0100, Nick Dixon wrote:
> I'm trying to build a simple Catalyst CRUD application using
> DBIx::Class 0.08010 and DBD::Sybase connecting to a SQL Server 2005
> instance.
> 
> I've installed DBIx::Class::Storage::DBI::Sybase and ::Sybase::MSSQL of course.

Those are part of DBIx::Class. You shouldn't have needed to install them
separately.
 
> Now selects work fine, but whenever I try to insert a record with
> DBIx::Class::ResultSet::create I get:
> 
> DBI Exception: DBD::Sybase::db ping failed: Can't call ping() with
> active statement handles at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/Class/Schema.pm line 954

Your DBD::Sybase's ping() method is broken.

If you can't get a working DBD::Sybase build I suggest you try ODBC instead.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/