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

[Alan Humphrey]

> > 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.

- Alan