Execute SQL Server Procedure from the iSeries

15 pts.
Tags:
AS 400
iSeries
SQL Server
Stored Procedures
I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Sounds like you are looking to create something similar to a web service. Check out a few sites to get an idea of how it's done. Aaron Bartell has a lot of great info on the process. Try it and come back if you still have issues with some sample of your code and we can help you figure it out.
    131,595 pointsBadges:
    report
  • sonorato
    Todd, perhaps that is what they are looking for here. The SQL Server URL I have is internal to this company. I also have an IP address for the MS SQL Server application. With these addresses I was hoping that the System i could connect to the MS database and allow us to run SQL or call Stored Procedures on that platform. Simply defining it to the AS/400 has not been successful (which I figured) as when I try to connect (with a valid Id & Password) it denies access. Also, since I am not involved with the system hardware or configuration at this account (as I am solely a Business Analyst and iSeries programmer), I will have to pass your advice on to those responsible. I was hoping for an easy way to get into the SQL Server database from the iSeries, so any other advice would be appreciated. Thank You
    15 pointsBadges:
    report
  • ToddN2000
    What type of connection string are you using to get to the SQL server? Another good resource is Scott Klement. He has some good demos and sample code.
    131,595 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: