June 1, 2012 at 8:03 am
In SQL 2005, while executing an query which calls websphere, we get below error
Error|Source|Description|HelpFile|HelpID
0x80070057|ODSOLE Extended Procedure|The parameter is incorrect|NULL|0
We also get the results. Does anyone have an idea on explain the above error and the possible ways to resolve it.
Version: SQL 2005 9.00.4053.00 SP3
June 1, 2012 at 9:25 am
are you using SP_OA calls?
please can you post the code that generates the error...
that error is typically a COM/REGISTRY issue for an sp_oa call to a DLL
MVDBA
June 1, 2012 at 8:11 pm
Mike,
We are using sp_OACreate, sp_OAGetErrorInfo, sp_OAMethod, sp_OAGetProperty, sp_OADestroy.
Error occurs only for some of the records which satisfies a particular condition and not for all records. Even though, we get the error, we do also get the results.
Meanwhile, I would try to post the code too after sterilising it.
June 6, 2012 at 4:05 am
balasach82 (6/1/2012)
Mike,We are using sp_OACreate, sp_OAGetErrorInfo, sp_OAMethod, sp_OAGetProperty, sp_OADestroy.
Error occurs only for some of the records which satisfies a particular condition and not for all records. Even though, we get the error, we do also get the results.
Meanwhile, I would try to post the code too after sterilising it.
then i would suggest that your dll is firing an error when those particular conditions are met
MVDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply