Btw, my dbd error (which is a tad different is:)
DBD::Sybase::db do failed: Server message number=2603 severity=21 state=1 line=1 server=pelicanprocedure=*00005400002531_3fa17ftext=Insufficient space (197 bytes) on logical page 87246 of index 3 for object 'attributes_string' when inserting row of length 200 bytes on index page. Any help would be valued. Cheers. R Raf said: > > I saw this post, which doesn't appear to have been followed up: > > http://lists.ibiblio.org/pipermail/freetds/2002q1/006299.html > > I have the same problem: > > Where: > (4) attribute_value varchar(350) NOT NULL > > =head2 MyError > > 1> insert into attributes_string ( > object_id,attribute_id,object_insert_id,attribute_value,creation_time,modification_time,modified_by > ) values (18, 75, 7236, > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' > ,'2003/07/01', '2003/07/01',2) > 2> go > Msg 103, Level 15, State 1: > Server 'pelican', Line 1: > The identifier that starts with 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too > long. Maximum length is 30. > > =cut > > This crashed my transaction and is giving me the same result in isql and > via DBD::Sybase. > > I know that it's not dbi specific , however it works when I reduced the > string "a"x350 to "a"x10. Given that the field is varchar(350) I really > don't get this? > > I've just moved to sybase from postgrest,sql,oracle and wonder if this > error is familiar to other developers? > > Cheers, > > Raf
