469,963 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

RecordSet Error...Unable to call the COM Component

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
Mar 26 '08 #1
6 1326
DrBunchman
979 Expert 512MB
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
Mar 27 '08 #2
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
Mar 27 '08 #3
DrBunchman
979 Expert 512MB
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?
Mar 27 '08 #4
jhardman
3,406 Expert 2GB
I didnt know you could do a response.redirect like that at all. Are you just trying to call a stored procedure?

Jared
Mar 28 '08 #5
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...
Mar 31 '08 #6
DrBunchman
979 Expert 512MB
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?
Apr 1 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Johan Lachonius | last post: by
6 posts views Thread by Karl Stankiewicz | last post: by
2 posts views Thread by DazedAndConfused | last post: by
3 posts views Thread by tshad | last post: by
reply views Thread by ritesh.singhal | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.