Solved

Using a MsDb2DataReader with a Stored Procedure

Posted on 2006-11-03
2
307 Views
Last Modified: 2012-05-05
I am using Host Integration Server and need to use a MsDb2DataReader to call a stored procedure. I will be creating an array of MsDb2Parameter objects, which I will be passing to the procedure.

The problem is that I can't find any examples of how to do this. The available MSDN documentation is sparse, and doesn't have what I'm looking for.

Has anyone done this? An example would be greatly appreciated.

Thanks!
0
Comment
Question by:marmaxx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
mjmarlow earned 500 total points
ID: 17872853
I read http://msdn2.microsoft.com/en-us/library/ms945832.aspx and see that the only quirk with the DB2 provider is the parameters must be added to parameter collection in same order they are defined (names are ignored).  Use this tutorial http://www.dbazine.com/sql/sql-articles/cook6 to see how it is done.

- Mark

0
 

Author Comment

by:marmaxx
ID: 17935076
Thanks Mark!
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question