RE: Remote Connecting to MS SQL Server

["Himes, Jay" <jehimes@xxxxxxxxxxx>]

There are several ways to do so. The one that we use here is java programs
using JDBC and a type 4 driver for SQL server. The obvious limitation for
this method is that you must use java any time you wish to access SQL
server.

I believe that MS SNA server (the name has changed - I don't know the new
name) offers the ability to use DRDA to SQL server; but I have never tried
to do so.

Jay Himes
Liberty University

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wills, Mike N. (TC)
Sent: Friday, April 02, 2004 3:38 PM
To: Midrange Systems Technical Discussion
Subject: Remote Connecting to MS SQL Server

With all the talk the other day about remote connecting to Oracle, I though
I should ask about MS SQL. Does anyone know if it (or how) is possible to
remote connect to a MS SQL server and process the information remotely.
Thanks for any info.

Mike Wills
Lawson Programmer/Administrator
Taylor Development
Email: mnwills@xxxxxxxxxxxxxx
Direct Line: (507) 386-3187

CONFIDENTIAL INFORMATION

NOT TO BE COPIED WITHOUT AUTHORIZATION

The information contained in this electronic mail transmission may contain
privileged communications and/or confidential information intended only for
the use of the named recipient(s).  If the reader of this information is not
the named recipient(s) or you receive this transmission in error, please:
(1) immediately notify us by return electronic  transmission at
mnwills@xxxxxxxxxxxxxx; and (2) permanently delete this message from your
computer and all servers and other stored devices.

_______________________________________________
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.