ODBC SQL Statement length limit of 64k???

ODBC SQL Statement length limit of 64k???

Post by Steve » Tue, 09 Sep 1997 04:00:00

I have written a VB5 application that inserts data into a SQL Server table.
I am using an ODBCDirect workspace, and the EXECUTE method to run the sql
insert statement. The table has four fields, one of which is TEXT, allowing
very large text data to be inserted. When one of my users tried to insert a
row that resulted in a sql statement that exceeded 64k, he got an ODBC call
failed msg. When we shortened the data slightly, it worked. What are the
rules here?



1. SQL statement length limit?

Is there a limit to the length of a SQL statement that can be handled by
SQL Server 6.0?  And would there be any serious performance problems
with a statement of the form "select a, b, c from x where id = 123 or id
= 456 or id = 789 or id = 234 or id = 234 ..." assuming that id is a
unique, indexed column?

2. If Statement..

3. SQL statement length limits

4. Florida-Oracle GL Specialist

5. Limit to the Length of the SQL statement

6. truncating values on insert ?

7. String length limits hit in SQL statement

8. Status - Jan 29, 99

9. 64k BLOB limits in VB & ODBC

10. limits of SQL statement length

11. Limit to length of string displayed in SELECT statement

12. Length limit in Informix ODBC 3.34, Win 2000?