See iSeries Network: MySQL Database Access from RPG <BR>
Article ID: 52433 by Scott Klement

These two posts show an alternative method of accessing data using SQL wrappers around Java calls to SQL Server. <p><a href="http://www.mcpressonline.com/mc? This e-mail address is being protected from spam bots, you need JavaScript enabled to view it @.6aea26b5!sectionid=.5bfbaeaf">http://www.mcpressonline.com/mc? This e-mail address is being protected from spam bots, you need JavaScript enabled to view it @.6aea26b5!sectionid=.5bfbaeaf</a> <p><a href="http://www.mcpressonline.com/mc? This e-mail address is being protected from spam bots, you need JavaScript enabled to view it @.6b2030a3!sectionID=.5bfbae47">http://www.mcpressonline.com/mc? This e-mail address is being protected from spam bots, you need JavaScript enabled to view it @.6b2030a3!sectionID=.5bfbae47</a>

You can use a product called SQL iPlug from Aura-Equipement. <BR>
We use it for manufacturing tasks in one of our plants (order processing, tracking), all in interactive mode, and it is quite effective. <BR>
You can check it all at <BR>
<a href="http://www.easycom-aura.com/us/SQL_iPlug.asp">http://www.easycom-aura.com/us/SQL_iPlug.asp</a>

I have a need to access an MS SQL db from an RPG program running on our AS400. <p>Support (800-IBM-SERV) said that I could use a "Type 4" JDBC driver or DB2 or DRDA. They also said that DB2 was pretty pricey. (We have a P10 box.) Support also said that DRDA, while not officially supported by MS SQL, could be made to work. This is a less appealing option for me from the start. <p>Response time is a major factor as this will be initially used in an interactive application. <p>Anybody ever done this ? <p>Martin