Re: DRDA / MS SQL Server

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Bill, in order to talk to SQL Server using embedded SQL, Microsoft 
has to give you what is called an "application request driver 
program". This is not something IBM will or should provide - it is 
just like the need for vendors to provide ODBC drivers for Windows to 
get to their data. I do not see that this is part of HIS. David 
Delisi can comment further, I hope. HIS seems to be only for getting 
to iSeries and other IBM platforms from Windows, not the other way around.

I am very interested in whether MS has provided this ARDPGM for the 
iSeries - it would be named on the ADDRDBDIRE command, to register 
the SQL Server system for use in RPG programs with embedded SQL. IBM 
has provided its WebSphere Data Integrator (whatever the name - I 
lose track) that has an app running on a Windows box that uses ODBC 
or OLE/DB to talk to whatever database. And it is DRDA-enabled. But 
you don't want to know how expensive it is.

I work for a company that has an alternative solution (blatant vendor 
response here). If HIS gives you the ability to get to SQL Server 
data FROM an RPG program, then go with that. Otherwise, you could 
look at our RPG2SQL product. It is similar in architecture to the IBM 
product, in that there is a PC server app in the middle that uses 
available ODBC or OLE/DB resources. One thing it does allow that 
embedded SQL does not is, several connections can be left open, with 
record positioning intact.

Anyway, if interested, give me a shout at vern@xxxxxxxxxxxxxxx or 
888.RJS.SOFT and I can give you a quick demo. (end of blatant vendor response)

There is an article at www.iseries.ibm.com/db2 that discusses the 
several alternatives, including Java, our solution (in passing), and 
the IBM one, which it promotes. Kent Milligan wrote it, and it is a 
good article.

HTH
Vern

At 09:24 AM 2/15/2006, you wrote:

> Ok, I've searched and reviewed and know that this topic was covered here in
> the past but maybe someone has made progress with some of the new os
> releases?
>
> I need to connect to a SQL Server.  We've been using a JDBC connection that
> has been working well.  We're also using file 'feeds' which are a nightmare
> IMHO.  Now with more demand for additional data that is stored in the SQL
> Server, I'm taking a closer look.  They bought the Host Integration Server
> (HIS) software so that may be an option for access from the midrange machine
> as well.
>
> Does anyone have pointers on how to connect either directly to the SQL
> Server or how to utilize HIS from the midrange machine using embeded SQL?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.