Re: Problem with DBD::Sybase and SQL Server
Michael Peppler <[email protected]> Fri, 31 Oct 2008 07:23:59 +0100
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail-12-166420439 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit On Oct 30, 2008, at 9:16 PM, Wechsler, Steven wrote: > I have two hosts here. They are both using FreeTDS to talk to a SQL > Server. One is running DBD::Sybase v 0.95, and it works fine. The > other is running v 1.08, and it gets the following error whenever I > try to run any SQL command: > > $ run_sql.pl -S mtvu-sql-1 -q 'select @@servername' > Msg 3902, Severity 16, State 1: > Server 'MTVU-SQL-1', Line: 2: > The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. > ***** Running query against server mtvu-sql-1 at 10/30/08 15:57:36 > ***** > COL(1) > ---------- > MTVU-SQL-1 > ***** WARNING: Execution finished with warnings/errors at 10/30/08 > 15:57:36 **** > Could you please try DBD::Sybase 1.09 and see if that still has the error? Thanks, Michael -- Michael Peppler - Peppler Consulting SaRL [email protected] - http://www.peppler.org Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html --Apple-Mail-12-166420439 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable <html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; = -webkit-line-break: after-white-space; "><div><div>On Oct 30, 2008, at = 9:16 PM, Wechsler, Steven wrote:</div><br = class=3D"Apple-interchange-newline"><blockquote type=3D"cite"> <div> = <!-- Converted from text/rtf format --><p><font size=3D"2" = face=3D"Arial">I have two hosts here. They are both using FreeTDS to = talk to a SQL Server. One is running DBD::Sybase v 0.95, and it works = fine. The other is running v 1.08, and it gets the following error = whenever I try to run any SQL command:</font></p><p><font size=3D"2" = face=3D"Lucida Console">$ run_sql.pl -S mtvu-sql-1 -q 'select = @@servername'</font> <br><font size=3D"2" face=3D"Lucida Console">Msg = 3902, Severity 16, State 1:</font> <br><font size=3D"2" face=3D"Lucida = Console">Server 'MTVU-SQL-1', Line: 2:</font> <br><font size=3D"2" = face=3D"Lucida Console">The COMMIT TRANSACTION request has no = corresponding BEGIN TRANSACTION.</font> <br><font size=3D"2" = face=3D"Lucida Console">***** Running query against server mtvu-sql-1 at = 10/30/08 15:57:36 *****</font> <br><font size=3D"2" face=3D"Lucida = Console">COL(1)</font> <br><font size=3D"2" face=3D"Lucida = Console">---------- </font> <br><font size=3D"2" face=3D"Lucida = Console">MTVU-SQL-1 </font> <br><font size=3D"2" face=3D"Lucida = Console">***** WARNING: Execution finished with warnings/errors at = 10/30/08 15:57:36 ****</font></p></div></blockquote><div>Could you = please try DBD::Sybase 1.09 and see if that still has the = error?</div><div><br></div><div>Thanks,</div><div><br></div><div>Michael</= div><div>--</div></div><div apple-content-edited=3D"true"> <span = class=3D"Apple-style-span" style=3D"border-collapse: separate; color: = rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: = normal; font-variant: normal; font-weight: normal; letter-spacing: = normal; line-height: normal; orphans: 2; text-align: auto; text-indent: = 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: = 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><div><div>Michael Peppler = - = Peppler Consulting = SaRL</div><div>[email protected] - = <a = href=3D"http://www.peppler.org">http://www.peppler.org</a></div><div>Sybas= e DBA/Developer - = TeamSybase: <a = href=3D"http://www.teamsybase.com">http://www.teamsybase.com</a></div><div= >Sybase on Linux FAQ - = <a = href=3D"http://www.peppler.org/FAQ/linux.html">http://www.peppler.org/FAQ/= linux.html</a></div><div><br></div></div></div></span><br = class=3D"Apple-interchange-newline"> </div><br></body></html>= --Apple-Mail-12-166420439--