How do I call a remote procedure on iSeries from my C# application using OleDbCommand

Question

1.00/5 (1 vote)

See more:

Hi,
I have a remote procedure called TFARW on an iSeries. On the iSeries I can successfully run this remote procedure via SQL ( eg. CALL BPCSUSR/TFARW ('TEST') ). However when I try to call this same remote procesure from a c# application , it just hangs. I know that the iSeries connection string is correct as I am successfully reading DB2 files. Below is the c# code I am using to run the remote procedure:

C#

SQL="CALL BPCSUSR.TFARW('TEST')
OleDbConnection conn2 = new OleDbConnection(connectionString);
conn2.Close();
conn2.Open();

OleDbCommand cmd = new OleDbCommand(SQL, conn2);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Prepare(); 

cmd.ExecuteNonQuery();
conn2.Close()

When running in debug, is there any way I can determine why application is hanging ? Any ideas from the code above as to what I am doing wrong ?

regards
Pat

Posted 14-Jun-14 1:31am

PClarkeirl

Updated 14-Jun-14 2:22am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Jun-14 8:23am

I guess your SQL is wrong. It should only have the Procedure Name.

PClarkeirl 14-Jun-14 9:26am

I changed the code to SQL = BPCSUSR.TFARW('TEST') - Same result
I also tried SQL= BPCSUSR.TFARW and passed the parameter in via oleDbParameter - Same result

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PClarkeirl · Answer 1 · 2014-06-14T04:54:00

Solution 2

I have found the problem. My C# code was correct however the iSeries stored procedure was crashing which accounted for the C# application hanging. Once I fixed the source of the problem on the stored procedure then the call worked.

thanks to all who contributed

regards
Pat

Posted 14-Jun-14 4:54am

PClarkeirl