RE: Connecting Microsoft Solutions with legacy systems

["Holliday, Gary" <Gary.Holliday@xxxxxxxxxxxxxx>]

Phil Groschwitz wrote:
> In a TCP/IP environment where there is an AS/400 and
> NT on the same lan - SNA server is still what to use? 
> Is it using SNA or can it use TCP/IP between the two?

We have an AS/400 and two NT servers using TCP/IP, we don't have SNA Server.
I've used the Client Access ODBC driver to get data into our SQL Server data
warehouse. Works fine, the main gotcha I've found is that Client Access had
an older version of the MS Data Access Components, reinstalling the version
sorted that out.

I'd be interested to know any advantages SNA Server may bring us.

Gary





This e:Mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed.
If you have received this e-mail in error please contact Matthew Middleton
or Gary Holliday immediately by telephone on 01775 710789 or on e-mail at
Smedleys.IT@Smedleys.co.uk
Any views or opinions presented are solely those of the author and do not
necessarily represent those of Smedleys Foods.
Unauthorised publication, use, dissemination, forwarding, printing or
copying of this e-mail and its associated attachments is strictly
prohibited. 


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---