Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Linked Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-28 : 08:18:59
mhel writes "I have a stored procedure that uses a linked server to update/insert records on a remote table, specifically, an AS400 physical file. When the sp is executed using SQL Query Analyzer, the update/insert works, but when the same sp is called by a code-behind in ASP.NET, a timeout error occurs. When I traced it using SQL Profiler, the line containing the insert/update on the linked server object generates the following error:
"DBPROP_STRUCTUREDSTORAGE without DBPROPVAL_OO_BLOB being supported"

What does this error mean? Why does the same sp work in SQL analyzer, and not when called by an ASP.NET application?"
   

- Advertisement -