×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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?
midrange.com
