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