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: 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().

Michael


 > 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 http://www.hotmail.com
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com