Entry

Getting 0x80070057, 80070057 or 80004005 or 80040e14 with SQL Adapter.

Apr 6th, 2005 22:49
Balaji Ramachandran, http://biztalk-training.com/Default.aspx?tabid=57

There maybe other reasons for this message, but I was getting it when I 
was trying to map an incoming message to an updategram, and forgot and 
took the map off the receive port. Thus the message came in and was 
sent to SQL "as is" without being an updategram, causing this message. 
Basically, I was trying to do example #2 from Scott Woodgate's SQL 
Adapter called "Use SQL Adapter in Message-Only Scenario". 
Instead of dropping the updategram, I was mapping an EasyPO schema to 
the updategram using a simple map. Probably what happened is that I 
undeployed and had to remove the map, then redeployed and forgot to put 
the map back in. 
Other things to check: 
1) Check the application event log for more specific SQL errors 
2) Check to make sure the Host (Service) Userid has access to the 
database if you are running Windows Integrated security. 
Also leaving the map off can cause this misleading error (it says 
stored procedure found when I was not using a stored procedure). 
Apparently it was taking the first element name from the XML file and 
assuming it was a stored procedure name.) 
Description:
The adapter "SQL" raised an error message. 
Details "HRESULT="0x80040e14" Description="Could not find stored 
procedure 'PONum'."
".