RecordSet Error...Unable to call the COM Component

Question posted by: dotnetdev1 (Newbie) on March 26th, 2008 08:18 PM

Hi Friends,
I am new to the COM Programming..When I am executing the Code I am getting the following error..Please Help me...If anyone can understand what My error is....Thanks

Error Type:
DataAccessV2_2.clsFWDAC.DoRunSP()>Microsoft OLE DB Provider for SQL ServerclsCOMPHOHLD - SaveStudentInfo (0x80040E14)
Household Component Call Fails: SaveStudentInfo - clsCOMPHOHLD - SaveStudentInfo - (ApplicationNumber - 9000218 ) Error Desc: Invalid length parameter passed to the substring function. SPName=USP_UPD_STUD_INFO_EXT, Parameters: Param0 = 9000218; Param1 = 9000236~FU~88~NO~GED|9000240~HA~15~NO~GED; Param2 = HHSTU;
/assistdev/PGM/ASP/HHSTU.asp, line 126

The Code in Line 126 is as follows:

If Len(Request.Form("btn_Continue")) <> 0 then
Call DoValidate()

Call DoContinueDblClick("")
******Line 126*** Response.Redirect m_objHousehold.SaveStudentInfo()***Line 126****

If Err.number <> 0 then
Call DoLogError()
Response.End
End if

Thanks
DND

DrBunchman

Moderator

841 Posts

March 27th, 2008
09:36 AM
#2

Re: RecordSet Error...Unable to call the COM Component

Hi dotnetdev1,

I think that's a SQL Server error - have you got access to the stored procedure that's being called by SaveStudentInfo?

Dr B

dotnetdev1

Newbie

9 Posts

March 27th, 2008
02:09 PM
#3

Re: RecordSet Error...Unable to call the COM Component

Quote:

Hi dotnetdev1,

I think that's a SQL Server error - have you got access to the stored procedure that's being called by SaveStudentInfo?

Dr B

Hi DrB,
Thanks for your reply...How to check that whether I got the access to the stored procedure thats being called by savestudentinfo...Please guide me so that I can check on that....

Thanks
DND

DrBunchman

Moderator

841 Posts

March 27th, 2008
03:47 PM
#4

Re: RecordSet Error...Unable to call the COM Component

In the error message it refers to a stored procedure called USP_UPD_STUD_INFO_EXT - have you got SQL Server Management studio or Query Analyser or anything like that with which you can query the database and look at it's stored procedures?

The error suggests that a parameter is not being passed (or not passed correctly) so you may be able to see whether this is the case if you could look at the stored procedure.

Does this make sense?

Dr B

PS I may be barking up the wrong tree here - any experts out there seen this one before?

jhardman

Moderator

2,246 Posts

March 28th, 2008
03:58 AM
#5

Re: RecordSet Error...Unable to call the COM Component

I didnt know you could do a response.redirect like that at all. Are you just trying to call a stored procedure?

Jared

dotnetdev1

Newbie

9 Posts

March 31st, 2008
03:33 PM
#6

Re: RecordSet Error...Unable to call the COM Component

Quote:

I didnt know you could do a response.redirect like that at all. Are you just trying to call a stored procedure?

Jared

Thaks For your replies....I have checked the Stored Procedure and it looks very fine...I am using SQL Server enterprise Manager....and when I am comparing the stored procedure is fine...

DrBunchman

Moderator

841 Posts

April 1st, 2008
08:18 AM
#7

Re: RecordSet Error...Unable to call the COM Component

Quote:

I didnt know you could do a response.redirect like that at all. Are you just trying to call a stored procedure?

Jared

That's a good point - is that what this line is trying to do? Call a stored procedure?

Not the answer you were looking for? Post your question . . .
189,085 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Top ASP Forum Contributors