RE: DRDA / MS SQL Server

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Hi David

This all sounds like getting at data on the iSeries from a PC. I 
looked at your site on HIS, and the overview seems only to discuss 
using your product on Windows. It does use DRDA as the protocol for 
getting to the data with your ODBC or OLE/DB tools, I believe.

Does HIS have an ARD that installs on the iSeries, to let the iSeries 
work with SQL Server data through DRDA and SQL on the iSeries?

Thanks

At 12:51 PM 2/15/2006, you wrote:

> Assuming you are running HIS 2004, start here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200
> 4def/htm/his2004_def_portal_page.asp
>
> For development assistance, this link is useful:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200
> 4main/htm/his_dg_sdk_node_aflx.asp
>
> There is a new Managed Provider for DB2 that you should be aware of that
> allows users to access DB2/400 from within a managed code application,
> and serves as a bridge between a DB2/400 data source and an ADO Dataset.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnancho
> r/html/hostintegrationserver.asp
>
> There is also a new tool, DAT, which provides a single mechanism to
> guide you through configuring network, security, and database
> information, and creating packages for DB2.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200
> 4Main/htm/his_data_access_tool.asp
>
>
> If you require additional assistance, please feel free to contact me
> directly.
>
> Thanks,
>
>
> David deLisi
> Microsoft
> www.microsoft.com\midrange
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bill Meecham
> Sent: Wednesday, February 15, 2006 7:24 AM
> To: Midrange Systems Technical Discussion
> Subject: DRDA / MS SQL Server
>
> 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.
>
>
> --
> 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.