I am trying to execute one huge select statement from my application using ODBC, but I am getting this error:
[Microsoft][ODBC SQL Server Driver]String data, right truncation.
the select statement is bigger than 2000 characters, but I don't have any long string column, just strings and numbers. How can I work around this?
Is there any max size? Because if I use less than 1000 characters, it works fine.
I am using Centura/SqlWindows, Native Sql Server ODBC and SqlServer 2005. unfortunately, I can not use Ole from my application.
I checked all values, they are all correct, so I think could be another problem, but I don't have any idea.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?