Re: error - object already exists in database
Michael Peppler <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <[email protected]> |
On Mon, 2005-06-20 at 22:18, Alan Humphrey wrote: > 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, > <WORK> chunk 1. The most likely problem is that the default database for your perl connection is not the database where you want to create this object. So you drop it in one place, and create it elsewhere (most likely the master database). Make sure you "use" the appropriate database (or specify the "database" attribute in the connection string). Michael -- Michael Peppler - [email protected] - http://www.peppler.org/ Sybase DBA/Developer Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html