We have a vendor app that's written in a language that's close to VB4.
Wrote a stored proc in SQL Server with parameters and the vendor app calls it fine.
Wrote the same SP in AS400 (SQL stored proc, not an external one) and get this error:
the TCP/IP connection was terminated unexpectedly
-- Ran some tests:
I open iSeries Navigator and call the stored proc. It works fine.
My coworker used strsql and called it . it worked fine.
When we call it with NO parameters, it works fine.
Calling As400 from .Net app works fine.
Calling SQL Server stored proc from the vendor app works fine.
-- My coworker said when a SQL stored proc is created on AS400...AS400 creates that with extra parameters. We cant see these parameters How he found this out...i dont know. But is this true?
We called IBM and they said to create a CL.
Any ideas?
Wrote a stored proc in SQL Server with parameters and the vendor app calls it fine.
Wrote the same SP in AS400 (SQL stored proc, not an external one) and get this error:
the TCP/IP connection was terminated unexpectedly
-- Ran some tests:
I open iSeries Navigator and call the stored proc. It works fine.
My coworker used strsql and called it . it worked fine.
When we call it with NO parameters, it works fine.
Calling As400 from .Net app works fine.
Calling SQL Server stored proc from the vendor app works fine.
-- My coworker said when a SQL stored proc is created on AS400...AS400 creates that with extra parameters. We cant see these parameters How he found this out...i dont know. But is this true?
We called IBM and they said to create a CL.
Any ideas?
Comment