VB & Database, -2147217889 [ODBC SQL Server Driver] String Data, Right Truncation

-2147217889 [ODBC SQL Server Driver] String Data, Right Truncation

Author	Message
Shirley Yan #1 / 3	-2147217889 [ODBC SQL Server Driver] String Data, Right Truncation I tried to pass a text report to SQL Server DB by calling a stored procedure from VB. The following code is Dim cmd ADODB.command Dim param As ADODB.Parameter cmd.CommandText = "test_passed_text" cmd.CommandType = adCmdStoredProc Set param = New ADODB.Parameter Set param = cmd.CreateParameter("TextReport", adBSTR, adParamInput,64000,sTextReport) cmd.Parameters.Append param cmd.Execute PS: sTextReport is a 29K report. The stored procedure "test_passed_text" is CREATE PROCEDURE test_passed_text AS RETURN After running my VB code, I got an error message "- 2147217889 [ODBC SQL Server Driver] String Data, Right Truncation". I use VB6 running on Win2000 server with SQL2000. ADO is a 2.1 version. Any idea??? Thanks Shirley
Sun, 26 Jun 2005 12:58:31 GMT

#2 / 3	-2147217889 [ODBC SQL Server Driver] String Data, Right Truncation
Fri, 19 Jun 1992 00:00:00 GMT

Sukesh Hooga #3 / 3	-2147217889 [ODBC SQL Server Driver] String Data, Right Truncation Quote: > I tried to pass a text report to SQL Server DB by calling > a stored procedure from VB. The following code is > Dim cmd ADODB.command > Dim param As ADODB.Parameter > cmd.CommandText = "test_passed_text" > cmd.CommandType = adCmdStoredProc > Set param = New ADODB.Parameter > Set param = cmd.CreateParameter("TextReport", adBSTR, > adParamInput,64000,sTextReport) > cmd.Parameters.Append param > cmd.Execute > PS: sTextReport is a 29K report. > The stored procedure "test_passed_text" is > CREATE PROCEDURE test_passed_text > AS > RETURN > After running my VB code, I got an error message "- > 2147217889 [ODBC SQL Server Driver] String Data, Right > Truncation". > I use VB6 running on Win2000 server with SQL2000. ADO is a > 2.1 version. > Any idea??? > Thanks > Shirley --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.435 / Virus Database: 244 - Release Date: 30/12/2002
Sun, 26 Jun 2005 17:42:50 GMT

Page 1 of 1

[ 3 post ]