Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Problem updating Text Column
Date: Mar 8 2000 3:14PM

Ernest Wong writes:
 > I tried updating the column to " " first, and then update the column with my 
 > data, this time I get this message:
 > Server message:
 > Message number: 7130, Severity 16, State 1, Line 1
 > Message String: WRITETEXT with no log is not valid at this time.  Database 
 > school must first be configured for this.
 > Does it mean the transaction log?  If so, I already have it configured.  Any 
 > Hints?

You need to set the 'select into/bulk copy' option to true for that
database, or use the logging version of dbwritetext().


 > Cheers.
 > >
 > >Hmmm - I've seen this before somewhere, but I don't remember the
 > >situation exactly.
 > >
 > >I think the problem was with having the TEXT column nullable, but on
 > >the other hand I'm pretty sure that I've used the nullable feature
 > >before.
 > >
 > >Just as an experiment, could you try updating the column to "" (empty
 > >string) before running the script and see if that fixes the problem?
 > >
 > >Michael
 > ______________________________________________________
 > Get Your Private, Free Email at

Michael Peppler         -||-  Data Migrations Inc.    -||-
Int. Sybase User Group  -||-
Sybase on Linux mailing list: