Database Server

[BPConnor]

I know I am missing the obvious here, but cannot resolve this issue. I am running ERP 8.0 on an AS/400(US) trying to connect to some EDI tables that reside on a SQL server(UK). I do NOT have JDE installed on the SQL server. I have created datasources (JDBNET) and OCM pointing to the database for both system and servermap. I am able to connect and view the tables via UTB, and the EDI upload UBE runs fine locally. The problem comes in when I run the upload on the server. It returns the errors shown in the logs attached.
Any assistance will be humbly appreciated.

 

[schwaac]

The JDBNET datasource for the AS/400 enterprise server has to point an E1 application server that is able to connect to the SQL 2000 server. That means that you have to install the OneWorld services on an Intel box. This should be a local server close to the OneWorld database server. It is not necessary to use the EDI server for this purpose.
JDBNET works in that way that it addresses SQL requests from or to AS/400 by means of the new IntelNT box, the results are returned within the JDE middleware.
Reports running on the AS/400 server connect via JDBNET to the IntelNT box, which acts as a proxy for the desired datasource pointing to the SQL 2000 server.

I hope that helps a little bit to understand how JDBNET works.