RE: [sqr-users] Error: Buffer overflow converting characters fromclient into server's character set.

[cluenek <cluenek@yahoo.com>]

More usefull/useless information:

The string for $home_price_date is passed in as part
of the orcsqr command line arguements.  ocsqr is our
custom sqr to incorporate c calls with the sqr code.

#ifdef home_price_date
    move '{home_price_date}' to $home_price_date
#endif

--- cluenek <cluenek@yahoo.com> wrote:
> 
> You are correct sir.  Although, I don't believe
> initial string is declared.
> 
> 
> --- "Knapp, Richard" <KnappR@umsystem.edu> wrote:
> > 
> > So, let me see if I have the facts straight - if
> you
> > run the stored proc as is, stuffing the output
> into
> > a (declared?) string, it produces the overflow
> > error.  If you put the output of the same proc
> into
> > an (undeclared) string (defined in some default
> > way?), there is no error.
> > 
> > Is this a fair description?
> > 
> > Richard Knapp
> > Database Programmer/Analyst
> > Institutional Research and Planning
> > University of Missouri System
> > 573-882-8856
> > knappr@umsystem.edu
> > 
> > 
> > -----Original Message-----
> > From: sqr-users-admin@sqrug.org
> > [mailto:sqr-users-admin@sqrug.org]On
> > Behalf Of cluenek
> > Sent: Friday, February 27, 2004 5:09 PM
> > To: sqr-users@sqrug.org
> > Subject: RE: [sqr-users] Error: Buffer overflow
> > converting characters
> > from client into server's character set.
> > 
> > 
> > 
> > I'm pretty sure it's not used in a following
> query. 
> > It does get passed into a c function down the
> road.
> > If
> > I change $home_price_date output to
> > $home_price_date_test, there is no problem.  Man
> > this
> > is strange.
> > 
> > Thanks again for the assistance.
> > 
> > --- "Knapp, Richard" <KnappR@umsystem.edu> wrote:
> > > 
> > > Is the null field used as a key in the next
> query
> > > down the line?
> > > 
> > > Richard Knapp
> > > Database Programmer/Analyst
> > > Institutional Research and Planning
> > > University of Missouri System
> > > 573-882-8856
> > > knappr@umsystem.edu
> > > 
> > > 
> > > -----Original Message-----
> > > From: sqr-users-admin@sqrug.org
> > > [mailto:sqr-users-admin@sqrug.org]On
> > > Behalf Of cluenek
> > > Sent: Friday, February 27, 2004 3:59 PM
> > > To: sqr-users@sqrug.org
> > > Subject: Re: [sqr-users] Error: Buffer overflow
> > > converting characters
> > > from client into server's character set.
> > > 
> > > 
> > > 
> > > I've narrowed down the problem I am having. 
> > > Basically
> > > the output value of the stored procedure below
> is
> > > causing the problem.
> > > 
> > > execute homehost_price_sync #home_price_file,
> > > $home_price_date, $host_price_date,
> > $home_price_date
> > > output
> > > 
> > > The value getting returned is null, not sure if
> > this
> > > matters, with regards to the subject: error
> > > statement.
> > >  If I comment out this procedure the same error
> > > occurs
> > > on a different procedure.  Not all stored
> > procedures
> > > are having this problem though.
> > > 
> > > Any ideas anyone.
> > > 
> > > Thanks
> > > 
> > > --- cluenek <cluenek@yahoo.com> wrote:
> > > > Thanks for the response.  Very strange, this
> > error
> > > > occurs in 6.0, but not 3.0.  Is there some
> kind
> > of
> > > > sqr
> > > > arg that may not be set for my newly installed
> > > > version
> > > > 6.0.  We are not converting to another db
> > > > manufacturer.  Sticking with ase 11.9.3. 
> > > Eventually
> > > > we will upgrade to 12.5
> > > > 
> > > > 
> > > > ATTACHMENT part 3.3 message/rfc822 
> > > > Subject: RE: [sqr-users] Error:  Buffer
> overflow
> > > > converting characters from client into
> server's
> > > > character set.
> > > > Date: Wed, 25 Feb 2004 16:52:31 -0600
> > > > From: "Knapp, Richard" <KnappR@umsystem.edu>
> > > > To: <sqr-users@sqrug.org>
> > > > 
> > > > I think the error message tells the tale.  You
> > are
> > > > attempting to call a stored procedure at a
> time
> > > when
> > > > the db is processing another command.  Are you
> > > also
> > > > converting from one db manufacturer to
> another?
> > > > 
> > > > Richard Knapp
> > > > Database Programmer/Analyst
> > > > Institutional Research and Planning
> > > > University of Missouri System
> > > > 573-882-8856
> > > > knappr@umsystem.edu
> > > > 
> > > > 
> > > > -----Original Message-----
> > > > From: sqr-users-admin@sqrug.org
> > > > [mailto:sqr-users-admin@sqrug.org]On
> > > > Behalf Of Ken Ulc
> > > > Sent: Wednesday, February 25, 2004 4:37 PM
> > > > To: sqr-users@sqrug.org
> > > > Subject: [sqr-users] Error: Buffer overflow
> > > > converting characters from
> > > > client into server's character set.
> > > > 
> > > > 
> > > > Hello All,
> > > > 
> > > > I'm trying to upgrade from SQR V3.0.7.1 to SQR
> > > V6.0.
> > > > 
> > > > Yes, I know it's a big jump, but I'm trying
> > > anyway. 
> > > > When I try to run my report, I get the below
> > error
> > > > message and I'm not sure where to begin.  How
> > can
> > > I
> > > > tell which sql statement within SQR is having
> > the
> > > > problem?  Where is cursor 75.  Any insite on
> > > > upgrading
> > > > to V6.0 would also be helpful.
> > > > 
> > > > Thanks,
> > > > 
> > > >
> > >
> >
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > > 
> > > > (SQR 5528) Sybase CT_RESULTS error in cursor
> 75:
> > > >    (2404) Buffer overflow converting
> characters
> > > from
> > > > client into server's character set.
> > > > 
> > > > Error on line 65:
> > > >    (SQR 3913) Could not EXECUTE stored
> > procedure.
> > > > 
> > > > SQR: Program Aborting.
> > > > (SQR 5528) Sybase dblogf: ct_send error in
> > cursor
> > > 0:
> > > >    (16) ct_command(): user api layer: external
> > > > error:
> > > > This routine cannot be called while results
> are
> > > > pending for a command that has been sent to
> the
> 
=== message truncated ===


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users