PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Rafael Kitover <rkitover at cpan dot org>
Subject: MSSQL + DBD::Sybase + FreeTDS + Transactions
Date: Dec 30 2010 12:09PM

Hello,

I'm working on transaction support for DBIx::Class when using
DBD::Sybase with FreeTDS and MSSQL.

$dbh->begin_work et. al. seem to be ineffective, and the only way to
start a transaction is $dbh->do('BEGIN TRAN').

It also seems that $dbh->do('ROLLBACK') is sometimes ignored, and the
only way to rollback reliably is to disconnect.

Is my understanding of this configuration correct?

Any suggestions would be highly appreciated.