I have replied you in another post:
===================
Some suggestions:
1. Run the stored procedure directly in Query Analyzer or other client tool
to see if the returned parameter works.
2. Made the syntax changes and ensured that the parameter object for the
return value is the first item in the Parameters collection per article
"Q308624 PRB: Output Parameters Not Returned w/ ADO.NET Command (VC++)"
http://support.microsoft.com/default.aspx?scid=KB;EN-US;308624
Additionally, ensure that the parameter's data type matches that of the
expected return value.
3. Make sure the latest version of the updates are applied:
- MDAC 2.8
- .Net Frameworks 1.1
- Microsoft Application Block 2.0
=====================
Sincerely,
Kevin
Microsoft Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! -
www.microsoft.com/security
--------------------
| Content-Class: urn:content-classes:message
| From: "Kurt Mang" <
[email protected]>
| Sender: "Kurt Mang" <
[email protected]>
| Subject: Output param trouble w/ Data Access Application Block
| Date: Sun, 21 Sep 2003 15:05:32 -0700
| Lines: 11
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOAjHmfWAxo9kTnTVW5gDJScYkv6Q==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:61734
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Hey all --
|
| I'm having a heck of a time getting the MS data access
| application block to return an output parameter for me.
| I've tried pretty much everything at this point.
|
| THE CODE:
|
| Dim params(13) As SqlParameter params =
| SR.SqlHelperParameterCache.GetSpParameterSet
| ("p_Member_InsertUpdate", False)
|