Error using SQL Data Adapter Update Command

G

Guest

I am using the SQL Data Adapter update command to update data in a SQL 2000
table. I am receiving the following error on the save.

"The query processor could not produce a query plan from the optimizer
because a query cannot update a text, ntext, or image column and a clustering
key at the same time."

The SQL table has one primary key and has a field with "text" data type.
This table also has cascade updates and deletes on child tables. The strange
thing is that this worked at one time; and nothing has changed as far as
fields and cascades go.

Using the SQL Data Adapter, I am able to update other tables that have text
data type and cascade deletes and updates.

What can cause this error?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VS 2003 & SQL 2005 Data Adapter Error 6
data adapter command type advise 1
SQL Server Error: 8629 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Why update of Text type column no work? 1
Reusing Adapter/Command Builder without disposing 1
Is it Posible Access VarBinary(MAX) From SqlDbType.Image 1
Invalid Column Name Sql-Error :Executing a stored procedure 1

Top