Skip to Content.
Sympa Menu

freetds - [freetds] String or binary data would be truncated

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Nguyen, Thi X." <tnguyen AT powertv.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] String or binary data would be truncated
  • Date: Tue, 19 Sep 2006 17:41:30 -0700

Hello all,

I am using DBD-ODBC 1.13, unixODBC 2.2.11, FreeTDS 0.64, MS SQL 2005,
and Perl
This is part of the Perl script:

-----------------------------------------------
# Assign this task
# End the Get Queue task in the Build Log table
$hDatabase->do("UPDATE BuildLog SET StepEnded = 1, Success =
1, "
. "BuildStepDuration = DATEDIFF (s,
BuildStepBegin, CURRENT_TIMESTAMP) "
. "WHERE BuildType = '$bld{BuildType}' AND
BuildCount = '$bld{BuildCount}' "
. "AND RequestDate = '$bld{RequestDate}' AND
BuildStep = 'Get Queue' ");

# Add new Get task in the Build Log table
print "Assigning new task: Get Code,$bld{BuildType},
$bld{BuildCount}\n";
$hStatement=$hDatabase->prepare("INSERT INTO BuildLog
(BuildType, BuildCount, RequestDate, BuildStep, "
. "MachineAssigned, BuildStepBegin, StepEnded,
Success ) "
. "VALUES ('$bld{BuildType}',
'$bld{BuildCount}', '$bld{RequestDate}', 'Get Code', "
. "'$bldMach', CURRENT_TIMESTAMP, 0, 0)");
$hStatement->execute()
or localDie "Couldn't execute statement: " .
$hDatabase->errstr;
$hStatement->finish;
--------------------------------------------

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

Please give me a pointer to go further. I spent so much the getting the
above combination (DBD-ODBC 1.13, unixODBC 2.2.11, FreeTDS 0.64, MS SQL
2005, and Perl) to work.

Thanks

Thi Nguyen


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





Archive powered by MHonArc 2.6.24.

Top of Page