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
You need to set the 'select into/bulk copy' option to true for that
database, or use the logging version of dbwritetext().
> >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
> >Just as an experiment, could you try updating the column to "" (empty
> >string) before running the script and see if that fixes the problem?
> Get Your Private, Free Email at http://www.hotmail.com
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: email@example.com