Solved

Using a MsDb2DataReader with a Stored Procedure

Posted on 2006-11-03
2
303 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
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now