Mega Code Archive

 

Categories / Delphi / ADO Database

 

memo too large error with mssql

Question: Using BLOB I/O an error, 'Memo Too Large' is returned. The error is: General SQL Error: 7134, unmapped [text: text table and table reference by the text pointer disagree.]. This is not a problem if the table does not contain a unique index. In this case all BLOB information is retrieved through the execution of the query. What does this error mean and how can I resolve it? Answer: A fix to MSSQL server is available from Microsoft: ftp://ftp.microsoft.com/bussys/sql/transfer/sql265i.exe - Intel Patch or ftp://ftp.microsoft.com/bussys/sql/transfer/sql265a.exe - Alpha Patch The password to use when extracting the files is "6.50.265" (without the quotation marks). To extract with the password, the syntax is: sql265i.exe -s6.50.265