How to read MS SQL tables using iSeries RPG

6435 pts.
Tags:
iSeries
RPG Program
SQL 2008
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

Software/Hardware used:
i5/OS 6.1, IBM iSeries

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    There is a product somewhere that claims to provide the capability. I might be able to track it down with a couple Google searches. But Microsoft doesn't supply a driver other than its JDBC driver (and doesn't implement full DRDA). Without a driver, SQL Server isn't going to let some remote system into its database. That gets into fundamental platform security. There is AppServer4RPG at Sourceforge [ http://sourceforge.net/projects/appserver4rpg/ ] that might make it reasonable. (I need to try it someday.) -- Tom
    125,585 pointsBadges:
    report
  • depeknow
    Look at http://www.scottklement.com/jdbc/ with his suggestions I read and update data from a MSSQL and a MySql DB for one of my customers. All with an old V5R4 OS version with some patches for Java on OS400 --- Depe
    40 pointsBadges:
    report
  • WoodEngineer
    Thanks for the tip, Depe. That looks good.
    6,435 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following