Re: DBD::Sybase::db do failed: Server message number=2762

From: Michael Peppler (mpeppler_at_peppler.org)
Date: 12/23/04

  • Next message: Owen: "DBD::SQLite and bind?" 
    To: dbi-users@perl.org
Date: Thu, 23 Dec 2004 21:40:57 +0100

    On Thu, 2004-12-23 at 15:10, Anderson, James (Company IT) wrote:
    > I googled and found a reference to this, but the link was dead :-( There
    > no longer appears to be anything in the mail archive.
    >
    > DBD::Sybase::db do failed: Server message number=2762 severity=16
    > state=3 line=1 server=NYTIBA8 text=The 'CREATE TABLE' command is not
    > allowed within a multi-statement transaction in the ...

    You can't create a table in a transaction, unless you have the "ddl in
    tran" option turned on for your database (which I *don't* recommend).

    Set AutoCommit=>1 to solve this problem.

    Michael 

    -- 
Michael Peppler  -  mpeppler@peppler.org  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
  • Next message: Owen: "DBD::SQLite and bind?"