FreeTDS Development Group

["Nguyen, Thi X." <tnguyen AT powertv.com>]

 Thanks for the quick response Mark. However, the same script has been 
working from a windows box, except that the DBD::ODBC module used is of 
Windows version.

-----Original Message-----
From: Robert Dobbs [mailto:bobisdobbs AT hotmail.com] 
Sent: Tuesday, September 19, 2006 5:48 PM
To: freetds AT lists.ibiblio.org
Cc: Nguyen, Thi X.
Subject: RE: [freetds] String or binary data would be truncated


>From: "Nguyen, Thi X." <tnguyen AT powertv.com>
>Date: Tue, 19 Sep 2006 17:41:30 -0700
>
>
> >From a Linux box, I am able to do the $hDatabase->do("UPDATE .....
>but the        $hStatement->execute() gives me error
>DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server] String or 
>binary data would be truncated. (SQL-22001)
>
>and the script quits.

It means the input exceeds the maximum length of the field definition, i.e. 
the field is VARCHAR(50) but your input is 52 characters.

Mark

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial!  
http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail


     - - - - - Appended by Scientific Atlanta, a Cisco company - - - - - 
This e-mail and any attachments may contain information which is 
confidential, proprietary, privileged or otherwise protected by law. The 
information is solely intended for the named addressee (or a person 
responsible for delivering it to the addressee). If you are not the intended 
recipient of this message, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
e-mail in error, please notify the sender immediately by return e-mail and 
delete it from your computer.