We help IT Professionals succeed at work.

SQL Server Error!

yysasa
yysasa asked
on
What is this error "Error 7143: Invalid locator de-referenced" means? Why it occurs? and how to solve it?

Comment
Watch Question

Commented:
see if this can help you, this is from MSDN


PRB: Inserting > than 250K of Data in a SQL 7 Image Field Fails

Q245714


--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft Visual FoxPro for Windows, version 6.0
Microsoft Data Access Components version 2.5

--------------------------------------------------------------------------------


SYMPTOMS
Inserting or replacing more than approximately 250K of data in an image field in a SQL 7.0 table, using a remote view, causes the tableupdate to fail. The following error message appears if you try to browse the table by double-clicking it in the remote view:

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid locator de-referenced.



RESOLUTION
Here are two ways to work around this problem:

Use a TABLEUPDATE(.T.) after the first replace statement. For example use the following code:



APPEND BLANK
REPLACE IID WITH RECCOUNT()+1, VERSIONNUMBER WITH 1, LASTUPDATE WITH DATETIME()
? TABLEUPDATE(.T.)
REPLACE  DBCFILE WITH REPLICATE("@", 200000), DCXFILE WITH REPLICATE("@", 250000), DCTFILE WITH REPLICATE("@", 900000)
? TABLEUPDATE(.T.)
-or-


Set the driver in SQL 6.5 compatibility mode. For more information on how to set the compatibility mode of the SQL driver, see the References section.




Explore More ContentExplore courses, solutions, and other research materials related to this topic.