SQL text string too long ??? (from excel to SQL server)

Hello everybody

I have a problem when I try to execute a store procedure in a sql server
from a VBA application made in excell, and when the string (SQL sentence) is
more than 255 caracters

simplify my program is like:

SQL_MIS = SQLOpen("DSN=name_of_the_ODBC_conexion") // opening the ODBC
connection

queryString = " bla bla bla ... "
// SQL sentence

text_SQLoutput = SQLExecQuery(SQL_MIS, queryString)
//execturion os the SQL sentence in the ODBC connection

If Not IsNumeric(text_SQLoutput) Then MsgBox ("Fallo: " + queryString)
//check if it has been ok

MsgBox (Len(queryString))
// check the length of the SQL sentence



and the SQL text string like: (two cases)


queryString = " dbo.EntityNEW 'new customer','','','','New
Customer','Aldioinert','ARGENTINA','que
impo','l','l','e','1','1','w','Discount stores','End User','Food
retail','Food retail refrigeration','non.applicable','','End
Users','¿?','A12345','2004-05-06','17:48:32' "

queryString = " dbo.EntityNEW 'new customer','','','','New
Customer','Aldioinert','ARGENTINA','que
impor','l','l','e','1','1','w','Discount stores','End User','Food
retail','Food retail refrigeration','non.applicable','','End
Users','¿?','A12345','2004-05-06','17:48:32' "


the first one is working, the second no, diferences??


queryString = " dbo.EntityNEW 'new customer','','','','New
Customer','Aldioinert','ARGENTINA','que impo'... ->255
caracteres
queryString = " dbo.EntityNEW 'new customer','','','','New
Customer','Aldioinert','ARGENTINA','que impor'... -> 256
caracteres


is it a limitation of the SQL-server?? is it of the ODBC
driver???
is there any way to solve it??




System spscification:
Windows Wxp
SQL-server 8.00.760 (SQL-server_2000)
driver ODBC: Microsoft SQL Server ODBC Driver Version 03.81.9042



thanks fot it.