RE: AS400 connect to SQL Server

["Chris Bipes" <chris.bipes@xxxxxxxxxxxxxxx>]

Since MS SQL and iSeries use different protocols for SQL they don't talk
directly.  IBM does not provide a OBDC driver for MS SQL.  However if
you know JAVA, you can use JBDC to do this.  Search the archives for
JBDC and SQL.  There are also third party software that runs on a server
to translate iSeries to MS SQL.

Christopher Bipes
Information Services Director
CrossCheck, Inc.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of jbuying@xxxxxxxxxx
Sent: Tuesday, May 22, 2007 2:35 PM
To: Midrange Systems Technical Discussion
Subject: AS400 connect to SQL Server

Greetings,

With all the MySQL talk, is there a way to connect my AS/400 to a M$ SQL
Server?

If I use the Add RDB Directory Entry (ADDRDBDIRE) is this possible?  I
think that I could then use the connect in the STRSQL and be seeing the
remote database.

Has anyone done this?