Re: ODBC FROM iSeries - huh?

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

This has been an area of tremendous frustration for me. AFAIK, the only
means iSeries has of working with a remote database is RDB, which uses
DRDA. This requires an ARD, an application requester device, as it's called.

IBM has told me that the vendor needs to provide this. That's like a
database vendor supplying an ODBC driver, I suppose. But there seems no
effort on IBM's part to abet this.

It will talk to any DB2/UDB database, AFAIK. SQL Serve, not to my knowledge.
The other post mentioned writing something that'd send requests to the
other DB server. I assume sockets would (could?) be involved. I don't know
enought nor have the time. Could someone in the open projects look at this?
It'd be fantastic, IMO.

At 10:54 AM 4/9/02 -0400, you wrote:
>OK, I've seen several posts like the following:
>
> >However, the iSeries can access outside data sources through DDM or ODBC.
>
>which claim that the iSeries can use ODBC to access data on another machine.
>IIRC there was even a thread about this the other week. However, can someone
>please explain this to me? I'm familiar with the SQL CLI, but that is a
>method for interfacing with the database layer in a platform independent
>manner, NOT a facility for accessing data on another machine.
>
>As I understand the SQL CLI I could write a C program on the iSeries that
>used the SQL CLI to access the database. In theory I could then take that C
>source code and compile it in Windows and it would access ODBC. Fine, but
>that is not the same as saying that the iSeries can access data using ODBC.
>
>What I want to know is the following: Can I take my SQLServer or Oracle or
>MySQL or ... ODBC drivers and load them on the iSeries so my programs can
>access data on these remote machines. I think not, but others seem to feel
>differently, please explain.
>
>-Walden
>
>
>------------
>Walden H Leverich III
>President
>Tech Software
>(516) 627-3800 x11
>(208) 692-3308 eFax
>WaldenL@TechSoftInc.com
>http://www.TechSoftInc.com
>
>Quiquid latine dictum sit altum viditur.
>(Whatever is said in Latin seems profound.)
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.