• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

What's the best to access MS Sequel Server data via ILE-RPG?

We have a local MS Sequel Server on the network. I need to access Sequel database info using our IBM i v7r1 via ILE-RPG program.
Any Takers? Thanks!
0
pipster1
Asked:
pipster1
  • 2
1 Solution
 
Gary PattersonVP Technology / Senior Consultant Commented:
IBM's solution ($$) is DRDA via the the IBM InfoSphere Federation Server (or whatever they call it today).

http://www-01.ibm.com/support/docview.wss?uid=nas8N1018120

Also other 3rd party products that can do the same.

Easiest way to DIY without spending money on software is JDBC.  Scott Klement has some open source code that makes it faster and easier to integrate.  I've worked with his code library in the past and though it isn't quite production-quality code, it really is a big time-saver over creating it yourself.

https://www.scottklement.com/jdbc/
1
 
pipster1Author Commented:
Thanks Gary
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Happy to help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now