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

[Peter Rabbitson]

Alan Humphrey wrote:
>>> 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
>>>
> 
> 
>> 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
>>
> 
> I ran the program multiple times it always failed in the same way.
> 
> I changed CHAINED to IMPLICIT_TRANSACTIONS in Storage::DBI::Sybase and the
> problem went away.  I don't know how general a fix that is but it did the
> trick for me.
> 

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)