Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 10-21-2004 16:55:44

newbie
Member
Registered: 08-15-2003
Posts: 85

Database Problem

Help!!!!

We are converting from .csv to MS SQL.  We’ve made the connection but when we try to convert a table we get this error:

DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. (SQL-22001) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: Execute immediate failed err=-1) at d:/inetpub/wwwroot/xxxxxxxxx/cgi-bin/shop/library/common/database.pl line 646.

Note: line 646 is as follows:
eval {$dbh_alt->do($sql_statement)};

Is anyone able to help us solve this problem?

Thanks,

Offline

 

#2 10-27-2004 09:57:10

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19514
Website

Re: Database Problem

Open up the file ./data/tables/altrdbms.csv for editing and add these two lines:

Code:


MSSQL_longtrunc,MSSQL,LongTruncOk,1,DISPLAY,,Y
MSSQL_longread,MSSQL,LongReadLen,75000,DISPLAY,,Y

Make sure to upload this file in BINARY mode.  This issue is not present in the latest versions of CCP5.1.


Nick Hendler

Offline

 

Board footer