'String data, right truncated. Error in parameter...' error
We are using ASE 12.5 as consolidated, ASA 9.0.2 3267 as remote. The upload_update script for our 'request_queue' table is failing with the following error: E. 08/14 14:55:43. Message: ODBC: [DataDirect][ODBC Sybase Wire Protocol driver]String data, right truncated. Error in parameter 3. (ODBC State = 22001, Native error code = 0). Table Name: Request_Queue. Primary Key(s): 11686 The definition of the remote table is as follows: CREATE TABLE "dbo"."Request_Queue" ( "Request_Queue_Id" unsigned int NOT NULL , "Client" ...

POSSIBLE BUG IN Win32 DBI INSTALL MODULE: DBI "prepare" no work FW: List 'dbi-users' closed to public posts
I have ActiveState Win32perl running. I installed fresh DBI, DBD, etc. from perl ppm.pl> prompt. But prepare( ) doesn't work (see below). perldoc DBI/DBD/DBI-FAQ are not useful since they assume it works. Any hints? Art www.mp3.com/ArthurSulit Classical Artist recently charted above Madonna -----Original Message----- From: Art Sulit [mailto:art@prs.net] Sent: Saturday, January 20, 2001 1:51 PM To: Webmaster@ActiveState.com Subject: POSSIBLE BUG IN YOUR DBI INSTALL MODULE: DBI "prepare" no work Hello, THERE IS A POSSIBLE BUG IN YOUR DBI INSTALL M...

Error RIGHT Truncation of string of data.
Hi there, I am having the error RIGHT Truncation of string of data. I am doing a procedure with 3 parameters in SYBASE I am using a temp table to produce a report later on. I did check the parameters lenght and each field of the table. in case I am trying to insert an string longer than I defined in the Database and in the temp table I am working on. .. Everyhings looks fine... Any other ideas? Thank you and enjoy the day Alice Leon aleon@sfu.ca AISG SFU Burnaby Campus CANADA ...

Error: right truncation of string data
Hi All, This is using SQL Anywhere 10. I have two users, both who are members of the same group. As far as I can tell they both have the same permissions. Using Sybase Central, I am able to go into a record in a particular table and modify a record, logged in as the other I get a "right truncation of string data" error. What could be wrong? Check the setting of the string_rtruncation option for the two users. -Dan "Brian Scanlon" <brians@spectradata.com> wrote in message news:462525f7$1@forums-1-dub... > Hi All, > This is us...

[perl5-dbi/dbi] 0c17b7: Include Jens' work for DBI-Test
----==_mimepart_521d9d9e8d573_74699e7d4814086d Date: Tue, 27 Aug 2013 23:50:06 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <521d9d9e8e411_74699e7d48140935@hookshot-fe4-pe1-prd.aws.github.net.mail> Branch: refs/heads/dir_search_hashes Home: https://github.com/perl5-dbi/dbi Commit: 0c17b78ff80873945276cd8ffc08876be8ebfd8d https://github.com/perl5-dbi/dbi/commit/0c17b78ff80873945276cd8ffc08876be8ebfd8d Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-08-12 (Mon, 12 Aug 2013)...

sp_iqcheckdb error "Right truncation of string data"
Hi all, When run sp_iqcheckdb 'allocation database' I get "Right truncation of string data". This also happens when I try repair or verify or when running allocation against some table. Also I get this error when using load table statement but not always. IQ 12.7 ESD 7 Linux x64 - Sybase IQ/12.7.0/090824/P/ESD 7/Enterprise Linux64 - amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp/64bit/2009-08-24 16:32:40 Why is this happening and how to solve it. ...

Infomaker 7.0.3 select error, string data right truncation
I have 7.0.3 with the latest EBF, build 10009. I have been getting periodic error messages. A report in one pbl will run fine and then the same or slightly modified report will run fine for a period in another pbl and then we start getting a Select Error, 01004, String Data, right truncation. I thought the problem was a single or double quote in some string data but I can get one report in one pbl run against the same data without a problem and then a copy of that report in another pbl works for awhile and then starts giving me this error message. Any help is appreciated...

String data, right truncation error with DBD::ODBC and MS SQL Server 2000
I'm using Perl, along with DBD::ODBC and MS SQL Server 2000, to create a weblog system... anyways, i gotta everything working right and i'm importing some old news records from another script's DB ( text file-based ) .. there are 108 records in total... everything goes fine ( DB is created, all other items are imported without problems ) until i hit one particular record. ####################################### ## Here is the DB structure i'm using: ## ####################### CREATE TABLE coranto_csql ( Coranto_newsid varchar(255) not null, Coranto_User ntext...

How to avoid "right truncation of string data" error during "dbunload -ar" ?
We build a program to convert databases from 8.0.3 to 10.0.1 for our customers. The only thing the have to do is a single click. At that moment we start a "dbunload -ar". Some of our curstomers get the "right truncation of string data" error. I know there is an option "string_rtruncation", but the default is "On". How can we avoid the "right truncation of string data" error during an "dbunload -ar"? Can we set the "string_rtruncation" option off during the "dbunload -ar" process? Data truncation should not be...

DBI:pg and DBI:db2 question...
Hello! I am porting an application from PostgreSQL to IBM-DB2 and need to know if it is possible/feasable to have both DBI:pg and DBI:db2 installed on the same machine. Any and all help is much appreaciated! Best regards Marvin Dickens On Sun, 23 Dec 2001 16:33:34 -0500, Marvin Dickens wrote: >I am porting an application from PostgreSQL to IBM-DB2 and need to know = if it=20 >is possible/feasable to have both DBI:pg and DBI:db2 installed on the = same=20 >machine. I assule it's DBD::pg and DBD::db2. Of course it's possible. You can even u...

DBI works, but CGI + DBI bombs?
Hello, I have 2 scripts below, where DBI is used in the former and DBI and CGI is used in the latter. The first script connects fine via command line, and the latter fails to connect, but using the same DBI code from the former. I'm puzzled and RTFM before deciding to send this email. Can anyone shed any light on why my script fails to connect when using CGI.pm? Thanks, Jonathan Gines Sr. Software Engineer #--------------------------------------------------------------------------------------------------------------------------------- # DBI script that connects f...

[perl5-dbi/DBI-Test] a2d1b2: create separate tests for DBI and DBI::Mock ...
----==_mimepart_51f946a54bb1b_2af891bd4c100430 Date: Wed, 31 Jul 2013 10:17:25 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51f946a54c721_2af891bd4c100582@hookshot-fe3-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/DBI-Test Commit: a2d1b22d134be0ca353e0f0b312fb14da24c798e https://github.com/perl5-dbi/DBI-Test/commit/a2d1b22d134be0ca353e0f0b312fb14da24c798e Author: Jens Rehsack <sno@netbsd.org> Date: 2013-07-31 (Wed, 31 Jul 2013) Changed ...

[perl5-dbi/dbi] 4fd6ec: Hardcoded version strings
----==_mimepart_51acd0ebc0406_5660739de483190 Date: Mon, 03 Jun 2013 10:22:51 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51acd0ebc1382_5660739de48326b@hookshot-fe6-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/dbi Commit: 4fd6ec60fbe40e9e6923e287ca8bdb83fcc633b0 https://github.com/perl5-dbi/dbi/commit/4fd6ec60fbe40e9e6923e287ca8bdb83fcc633b0 Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-06-03 (Mon, 03 Jun 2013) Changed...

String data, right truncated
Hi, when I try to synchronize between a handheld and a ASE I'm getting the error reported in the log attached at the end. This problem began when I migrated my database from ASA to ASE. This work perfectly with ASA but doesn't with ASE. Does anybody know how to correct this issue?. I'll appreciate any help LOG: I. 12/21 19:19:53. [0007]: upload_cursor INV_ENVASES (open for read and write): SELECT RUTA, CODIGO_PRESEN, DESCRIPCION_PRESEN, EXI_AYER, CARGA, DESCARGA, DEVOLUCION, EXI_HOY FROM INV_ENVASES WHERE RUTA = ? AND CODIGO_PRESEN = ? FOR UPDATE...