Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!

Thanx Brian... I'm losing this one!

I'm getting an access violoation on 'sqloledb.dll followed by another nasty
message something to do with an exception on ole32.dll...

I've dropped the return_value attack and have fallen back to a path that I'm
more familiar with. I'm basically copying the same model that I have in
numerous other applications and databases that work just fine. I've tried
deleting and rewriting the stored procedure, closing the connection and
reopening... checking parameters on the stored proc componenent... deleted
and recreated the 'user' on the server, verified rights... figured with the
errors that MAYBE my MDAC got corrupted somewhere along the line... so I
reinstalled that...

This is the first time that I've used 'refresh'... thinking that that will
setup my parameters and all I have to do is assign them... the error seems
to occur when I call 'open' on the stored proc... but (get this) NOT the
first time, but the second and subsequent times... what's up with that?

Thanx for your help!
b (getting desperate)
"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:mnot61hm7i824558ruop7o07tli3jv5s2a@xxxxxxxxxx
>
> >so... here I have a stored procedure...
> >
> >CREATE PROCEDURE dbo.getPayments @meetingCode char(6), @guestid char(10)
AS
> >return (select sum(a.amount) as payments from dbo.payments a
> >where (A.meetingCode= @meetingCode) and (a.guestid = @guestid)
> >group by a.guestid
> >)
> >GO
>
> The parameter is @Return_value and don't create your parameters
> just call Parameters.refresh
> --
> Brian Bushay (TeamB)
> Bbushay@xxxxxxxxx


.

Relevant Pages

  • Stored Procedure takes a stupidly long time
    ... mcdonalds takes about 4 secs. ... In my stored procedure I am looking at just short of 2 mins to get the same ... the first time i created one. ... something to compile it or is it already compiled. ...
    (microsoft.public.sqlserver.programming)
  • Re: The era of FORMAL NIGHTS is fading rapidly...
    ... Brian, please don't bring any of these delicacies to our Saturday luncheon! ... Nobody should have to eat deep fried tarantulas that have gone soggy for their first time. ... To toss things back on topic maybe you can have a "Candle Light Dinner" a la "Keeping Up Appearances" ...
    (rec.travel.cruises)
  • Re: Looping through a Datagrid
    ... line basis? ... > What you can do is instead of attaching to the reader, ... > to an OleDbCommand representing your stored procedure. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO faster than ADO.net ?
    ... Would you mind sending me back your changes so I can see what you did. ... Brian ... "Cor Ligthert" wrote: ... > I also added a procedure with a stored procedure and could win 20%. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Stored Procedure slow when called from Crystal Reports
    ... Access executes ... that statement to my stored procedure that is executed by the report, ... report runs about 3 times faster - almost as fast as the SP on its own. ... Yes, it is slow the first time, but that's before ...
    (microsoft.public.vb.crystal)