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!
Phillip KnoxSenior Systems AnalystAsked:
Who is Participating?
 
Gary PattersonConnect With a Mentor VP 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
 
Phillip KnoxSenior Systems AnalystAuthor Commented:
Thanks Gary
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Happy to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.