(th*******@gmail.com) writes:
I don't want to truncate it, i would like the whole data to be passed
through and inserted into the field. The field is of type TEXT (which
stores up to 2gig right?) so it should hold the amount of text i'm
wanting to insert. I think it's just a limitation of ADO and passing
that much data as a string possibly....
The error message is:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The identifier that starts with 'Long list of text that i'm trying to
insert' is too long. Maximum length is 128.
This is because you are delimiting a string literal with double
quotes. SQL Server uses single quotes for string delimiters. Double
quotes are for delimiting identifiers with funny characters in the
them.
And by the way, you should be passing you strings as parameters to
a command. If you send the SQL string, you will need to handle
embedded quotes.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp