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 MBAY dot NET>
Subject: what's the problem?
Date: Oct 23 1998 5:15PM

Nathan Pilatzke writes:
 > I have two error messages coming back to me and I'm not sure exactly what
 > either of them mean.  
 > 
 > Server message: (In srv_cb)
 > Message number: -131, Severity 0, State 0, Line 0
 > Server 'sqlsrvr2'
 > Message String: syntax error near '(end of line)'
 > 
 > Open Client Message: (In msg_cb)
 > Message number: LAYER = (1) ORIGIN = (4) SEVERITY = (1) NUMBER = (132)
 > Message String: ct_fetch(): user api layer: internal common library error:
 > The bind of result set item 1 resulted in truncation.
 > 
 > The first one seems non-fatal,

But is really weird. I've never seen a negative error message number
before... 


 > but the second one truncates the rather
 > large 'long binary' data that I'm trying to read from the database.

$dbh->ct_sql("set textsize xxx");

with xxx large enough for your binary data.

This can also be set via ct_option().

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