Connecting an AS/400 to a Foreign Data Source (SQL SERVER)

Hi list,

Is anyone out there successfully running a Table
Converter on the AS/400 Enterprise Server connecting
to a SQL Server 2000 database .

I have successfully run this Locally and all works fine.
Locally this has been setup as an ODBC connection.

Running on the Server I get the following errors.
3287 Tue Jan 28 04:36:14 2003
runbatch.c382
INITIALIZING RUNBATCH job: 99559

3287 Tue Jan 28 04:36:14 2003
ipcpub.c3121
process 3287 <B7334SYS/PRINTUBE>
registered in entry 11

3287 Tue Jan 28 04:36:14 2003
runbatch.c632
Startup for User=KEVINO9, Env=DV7333,
Job#=99559

3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90701 not found

3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST

3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90704 not found

3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST

3287 Tue Jan 28 04:36:17 2003
dbdrv.c1236
OS40001032 - DBTableExists: table
TESTDTA/F90703 not found

3287 Tue Jan 28 04:36:17 2003
jdb_drvm.c1520
JDB9900189 - Failed to verify that table
exists in Business Data - TEST

3287 Tue Jan 28 04:36:17 2003
combined.c344
RDEL0000045 - Could not open tables for
reliable event delivery (F90703 and F90704). Reliable
event delivery will be disabled

3287 Tue Jan 28 04:36:17 2003
runbatch.c1124
RUNBATCH: Remote CP=1252, Remote
OS=5, Local CP=37, ConvertToASCII=0

3287 Tue Jan 28 04:36:20 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed

3287 Tue Jan 28 04:36:20 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment

3287 Tue Jan 28 04:36:20 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test

3287 Tue Jan 28 04:36:20 2003
jtp_cm.c283
JDB9909003 - Could not init connect.

3287 Tue Jan 28 04:36:20 2003
jtp_tm.c960
JDB9909100 - Get connect info failed:
Transaction ID =

3287 Tue Jan 28 04:36:20 2003
jdb_rq1.c1797
JDB3100013 - Failed to get connectinfo

3287 Tue Jan 28 04:36:21 2003
jdbnsnrc.c128
BNT0000126 - Unable to receive message -
eConnectionFailed

3287 Tue Jan 28 04:36:21 2003
jdbnincn.c148
BNT0000026 - Unable to find remote
environment or user for new environment

3287 Tue Jan 28 04:36:21 2003
jdb_drvm.c680
JDB9900164 - Failed to connect to DMS
Interface - Test

3287 Tue Jan 28 04:36:21 2003
jtp_cm.c283
JDB9909003 - Could not init connect.


I have been looking at the following How to Knowledge
Garden documents.
These seems to say that this is possible and that the
connection is done using JDBNET as the Connector. So
we have set up the Data Source as connecting via
JDBNET.

Ott- 99-0045 Table Conversion/- Preparing a Foreign
Table at a Source

Ott-01-0111 What DLL to use on a OW Database Data
Source when preparing a Table Conversion to use a
Foreign Table

Also Chapter 20 of the below link RedBook
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg24
5195.pdf


Can anyone tell us if we are missing anything that is not
in the above How TO documents? I am still studying the
Rednbook.
Confirm that they are successfully using the above
process of running Table Converters………………
Confirm that OW Services need to be running on the
Remote Intel Server
(this is the next step we need to try)

Your help will be much appreciated .
Thanks in Advance

KOD

Platform:JDE OW XE/SP20/AS400 V4R5M0