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: "Alan Humphrey" <alan dot humphrey at comcast dot net>
Subject: error - object already exists in database
Date: Jun 20 2005 8:18PM

I'm trying to create tables via my Perl script, working against a remote
database.  The error returned is:

 

DBD::Sybase::db do failed: Server message number=2714 severity=16 state=6
line=1 server=GILGAMESH\BIRDWEB text=There is already an object named
'abundancies' in the database. at sql_server.pl line 74,  chunk 1.

 

The SQL being executed is:

 

CREATE TABLE  abundancies (

        bird_id integer not null,

        ecoregion_id integer not null,

        abundancy_notes text,

        january char(1),

        february char(1),

        march char(1),

        april char(1),

        may char(1),

        june char(1),

        july char(1),

        august char(1),

        september char(1),

        october char(1),

        november char(1),

        december char(1),

        PRIMARY KEY (bird_id, ecoregion_id)

)

 

The code looks like:

 

sub do_command {

            my $sql_command = shift;

            

            my $dbh = DBI->connect('DBI:Sybase:server='. $server, $user,
$pass, {RaiseError=>1, AutoCommit=>1})

              or die "Couldn't connect to database: " . DBI->errstr;

 

            $dbh->do($sql_command);

 

            $dbh->disconnect();

}

 

The reason I'm posting to this list is that if I execute the same command
from other tools (e.g. Query Analyzer) it works.

 

Any ideas?

 

- Alan