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



Eric

Those are the IBM approaches, also discussed in an article by Kent Milligan - title something like "Heterogeneous Data Access" - google on that and you should get close.

The Information Integrator named below has been renamed under the WebSphere umbrella, I think. It is quite costly, but it offers things like federation - where you CAN have tables from disparate RDBMS machines look like one database. Very cool!!

Our product, along with some others, is mentioned in that article. The article does focus on IBM's solution, of course. It is nonetheless and excellent resource.

So you get various choices - Scott's API that is free, something like ours that is low to medium cost, with additional features, and IBM's which is (was?) pricy but gives full embedded SQL usage.

HTH
Vern

elehti@xxxxxxxxxxxxxxxxxx wrote:
I thank all of you for your comments. Here is a response from IBM's tech support.
From: Vivian P Kirkpatrick : Accessing Data on Microsoft SQL Server from OS/400 or i5/OS

PMR 81473,370,000

Document Title:Accessing Data on Microsoft SQL Server from OS/400 or
i5/OS
Document Description:
IBM(r) OS/400(r) and IBM(r) i5/OS(r) support two open standards that
can be used
to access Microsoft(r) SQL Server data from an OS/400 or i5/OS
application.

The first method is through IBM(r) Distributed Relational Database
Architecture(tm) (IBM(r) DRDA(r)). OS/400 and i5/OS support DRDA as
both a client
(application requestor) and a server (application server). Although
DRDA
is an open standard, Microsoft SQL server does not currently support it
as
client or server. It is still possible to set up a workable
configuration;
however, another product is required to convert from DRDA to the SQL
Server's protocol. The IBM(r) WebSphere(r) Information Integrator
product can
be used for this conversion.

IBM's Information Integrator provides IBM(r) DB2(r) for OS/400(r) with
access to
a wide variety of databases. This includes the DB2 Family as well as
non-DB2 databases such as Oracle and SQL Server. DB2 for OS/400
utilizes
Information Integrator's capabilities with simple DRDA SQL requests.
Once
server mappings and nicknames have been defined in Information
Integrator,
the OS/400 SQL requests will look identical to accessing a remote DB2
for
OS/400 server. For more information on configuring Information
Integrator
for DB2 for OS/400, refer to the following Web site:

http://www-306.ibm.com/software/data/integration/

A second, more direct method for accessing SQL Server data from an
OS/400
or i5/OS application is to use a type 4 JDBC driver for SQL Server in an
OS/400 or i5/OS Java(tm) program. At the time this document was
written,
Microsoft offered a type 4 JDBC driver for SQL Server 2000 as a download
from their Web site. Several other companies also advertise type 4 JDBC
drivers for SQL Server.

IBM Software
Technical Document

Document Number: 15240922
____________________________________________________________
Functional Area: DB2 for i5/OS
SubFunctional Area: Distributed Relational Database
Architecture
SubSubFunctional Area: General
____________________________________________________________
Product: I5/OS (5761SS1DB); OS/400 DATABASE (5722SS1DB)
Release: V5R1M0; V5R2M0; V5R3M0; V5R4M0; V6R1M0

Classification: Public Use

Keywords:
____________________________________________________________

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.