RE: Connecting to a database that is on Microsoft SQL Server

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Rich_Weislak@xxxxxxxxx
> 
>    Is there a way from the 400 side to either make a link to a
Microsoft
> SQL Server database, I know I can copy it to the 400, but this
database
> has
> 4 + millions records in it, so if I could just some how create a link
to
> and open in up in a RPG program,

Check out my article:
http://www.mcpressonline.com/mc/1@xxxxxxxxxxxxxxxx@.6ae6296d!sectionID=.
5bfbae47

In there I talk about accessing SQL Server data from the iSeries.
Basically, you can use JDBC and a Microsoft-provided JDBC driver to
access the data.  You'd have to call this JDBC driver from your RPG
program.

Joe