RE: How do I connect from iSeries to MS SQL Server 2000?

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Joe,

My little point is, that you drag RPG into the discussion, while you offer an 
alternative with JDBC (using SQL) and the requestor tried to do it using 
SQL/400. And using embedded SQL in a HLL it should be possible as well, as long 
as the CONNECT TO functions.

The link I gave may help the requestor and others who try to solve this 
problem. It is a solution, perhaps the only one, java based. But to use two 
JDBC drivers to connect two different databases, as in this tip, would be a 
temporary solution for me.

It doesnot mean I disregard java solutions.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 7-6-05 at 12:28 Joe Pluta wrote:

>Carel, I'm sorry but I don't understand your point.  My point was that you can 
>access other databases using JDBC, provided they >have a Type 4 JDBC driver, 
>and so the iSeries doesn't need ODBC drivers.
>
>Not sure what your point about SQL/400 and RPG is...