AS/400 to Oracle


We have an AS/400 as our Enterprise server. We have some data on an NT box in an Oracle Database. The developers have written a UBE that when run locally will pull information from the Oracle DataBase. When the UBE is run on the AS/400 goes to "Error" status. In the log, it states that it can't connect to the database. Has anyone done something like this before? If so, could you give some guidance on how to set up the DB Datasource on the AS/400 to make sure we have it set up correctly? Also, if there are any requirements to have on the oracle side that would be helpful too.



Reputable Poster
Wade :

As far as I know, you can't define an AS/400 Enterprise Data Source
that points to an Oracle database, but you can define a System (Local)
Data Source that points to Oracle.
That explains why can you run it locally but not on the AS/400 server.



Active Member
I've worked on a similair configuration and we never got it going. The
solution we used was to put a seperate apps server with both an oracle
client and client access express on it. This could then run specific ube's
that needed to connect to oracle and the AS400. Just like a high spec client
We were told at the time that there were no drivers for the AS400 to talk to
Oracle. There may be some available now?


VIP Member
Hi Wade,

Although I have never had the need to configure it, I believe that JDBNet (not to be confused with JDENet) is your solution here.

The idea is that you run OneWorld services on your NT/Oracle box. It is essentially configured as an app/batch server. You can then configure your AS400's server map so that the datasource that should point to Oracle points instead to your app server with the type being JDBNET. When the AS400 needs to read from that datasource it pipes queries to the apps server, the apps server will retrieve the information and transmit it back to the AS400. This is all handled by the middleware.

Again, I have never done this. I do not know how well it works or how it performs as compared to other database drivers.

If you give it a try, let us know how it works out.


Justin Miller
[email protected]

working with B7332 and XE on AS/400, NT, Solaris and AIX


VIP Member
Hi Wade,

I think what you are looking for is JDBNet (not to be confused with JDENet).

From KG Document ott-99-0076
JDBNET is the process by which OneWorld® makes database requests across enterprise servers in an organization with non-homogenous solution.

JDBNET eliminates the need for database-specific network software. JDBNET on the client defines and bundles the database request. JDENET then transports the request to the server where the data request is to be processed. JDBNET on the server un-bundles and processes the database request, creates a new bundle of the output from the database request. Then JDENET transports the new bundle back to the client. JDBNET on the client then un-bundles the output and processes the data. JDBNET and JDENET are specific OneWorld® operation protocols.

You would install OneWorld services on the NT/Oracle machine. The AS400 server map datasource would then be configured to point to the NT machine with a type of JDBNet instead of Oracle. When the AS400 needed data from that

I have not ever had a need to do this. I can't tell you if it works reliably or how the performance compares to a direct database connection.

If you give it a try, let us know how it works out.


Justin Miller
[email protected]

working with B7332 and XE on AS/400, NT, Solaris and AIX