String Max Size on Stored Procedure Calling SQL Server

[lenin_7]

Hello, I'm working on a Stored Procedure called from Labview but I have a problem when I set a String Parameter greater than 11440 characters. 

I tried by executing this SP from SQL Server Query Window and it runs ok even when I input a bigger string. but when I do it from Labview I get the following Error:

I attach the VI that call's Stored Procedure.

Hope you can help me. 

[Dennis_Knutson]

That error is coming from ADO and not LabVIEW. The SQL Server query does not use ADO I believe. You may have better luck checking with Microsoft to see what limitations there are with ADO.

[Luis_CT]

Hello lenin_7,

As Dennis says, this error comes from the ODBC driver and not from LabVIEW, I found some Microsoft links that might help you with this issue:

http://www.lawebdelprogramador.com/foros/Visual_Basic_Avanzado/853535-Datos_tipo_string_-_Error_en_t...

http://code.activestate.com/lists/perl-win32-users/17716/

Hope this information works for you!