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: cannot insert text after new sybase install
Date: Feb 16 2000 2:59PM

Patrick S. Leung writes:
 > Hi Michael,
 > 
 > You are right.  I found the following message being hidden:
 > 
 > ..
 > Server message:
 > Message number 7130, Severity 16, State 1, Line 1
 > Message String:  WRITETEXT with no log is not valid at this time.
 > Database DEV1 must be configured for this.
 > 
 > However, I compare the options with sp_dboption of both database and they are
 > the same.  Would you have any quick suggest?  Sorry that I am not a fully
 > qualified DBA.

I believe that you need to have the "select into" option turned on.

Michael


 > Michael Peppler wrote:
 > 
 > > Patrick S. Leung writes:
 > >  > Hi,
 > >  >
 > >  > My production Sybase server is built from the very early download.  Due
 > >  > to load issue I have build a new one, from one of the Redhat 5.2
 > >  > application disk.  I have noticed that everything works except using
 > >  > sybperl ct_send_data to insert/update text fields, and it doesn't insert
 > >  > any more.  There is no error msg from Sybase nor the web server.  The
 > >  > perl scripts were running of the original web server, as I have only
 > >  > pointed the web server to the new database server.
 > >  >
 > >  > I suspect the Sybase rpm is of different version, as there is a
 > >  > difference in the language installation shell scripts.  Would that be
 > >  > possible?  Also, would upgrade to sybperl 2.11 helps?
 > >
 > > No - there is NO reason why ct_send_data should stop working, unless
 > > you have a difference in the tables, or something else that could
 > > cause this.
 > >
 > > Are you certain that there are no error messages? They could be hidden
 > > due to some filtering in the server message callbacks...
 > >
 > > Michael
 > > --
 > > 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
 > 
 > 
 > Hi Michael,
 > 

You are right.  I found the following message being hidden: >

.. >
Server message: >
Message number 7130, Severity 16, State 1, Line 1 >
Message String:  WRITETEXT with no log is not valid at this > time. >
Database DEV1 must be configured for this. >

However, I compare the options with sp_dboption of both database and > they are the same.  Would you have any quick suggest?  Sorry > that I am not a fully qualified DBA. >

Thanks a lot. >

Patrick >
  >

Michael Peppler wrote: >

Patrick S. Leung writes: >
 > Hi, >
 > >
 > My production Sybase server is built from the very early download.  > Due >
 > to load issue I have build a new one, from one of the Redhat > 5.2 >
 > application disk.  I have noticed that everything works > except using >
 > sybperl ct_send_data to insert/update text fields, and it doesn't > insert >
 > any more.  There is no error msg from Sybase nor the web > server.  The >
 > perl scripts were running of the original web server, as I > have only >
 > pointed the web server to the new database server. >
 > >
 > I suspect the Sybase rpm is of different version, as there > is a >
 > difference in the language installation shell scripts.  > Would that be >
 > possible?  Also, would upgrade to sybperl 2.11 helps? >

No - there is NO reason why ct_send_data should stop working, unless >
you have a difference in the tables, or something else that could >
cause this. >

Are you certain that there are no error messages? They could be hidden >
due to some filtering in the server message callbacks... >

Michael >
-- >
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

> -- 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