Re: DRDA / MS SQL Server

 
I have no idea what HIS is part of...my manager asked that I research this
so we could get it working on the midrange side.  The PC group actually has
all of the info, training, documentation, etc....we're just the midrange
mushrooms.
 
Thank you David and Steve!
 
bill

----- Original Message ----- 
From: Steve  <mailto:stephenrichter@xxxxxxxxx> Richter 
To: Midrange Systems Technical  <mailto:midrange-l@xxxxxxxxxxxx> Discussion 
Sent: Wednesday, February 15, 2006 2:06 PM
Subject: Re: DRDA / MS SQL Server


On 2/15/06, David Delisi <daviddel@xxxxxxxxxxxxx
<mailto:daviddel@xxxxxxxxxxxxx> > wrote: 
> Assuming you are running HIS 2004, start here: 
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200>  
> 4def/htm/his2004_def_portal_page.asp 

Is HIS part of the MSDN universal or premium subscription? 

-Steve 



> 
> For development assistance, this link is useful: 
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his_200
<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
<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
<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
<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? 
>