MS Access and DB2 Linked Tables Query

[gbradford3]

I can pull up an MS Access database, link DB2 tables to it (using a
System DSN) and create queries that return differences between a MS
Access table and a DB2 table. I am able to query both the MS Access
table and the DB2 table at the same time in the same SQL statement.

My problem is I am trying to duplicate this functionality in C# and I
cannot figure it out. The SQL that MS Access builds is:

SELECT DPS_OFFICE_ALIA S.TRADE_FIRM, DPS_OFFICE_ALIA S.TRADE_OFFICE
FROM (DPS_OFFICE_ALI AS LEFT JOIN 0001000_2006042 4_084844_O ON
(DPS_OFFICE_ALI AS.TRADE_FIRM = [0001000_2006042 4_084844_O].TRADE_FIRM)
AND (DPS_OFFICE_ALI AS.TRADE_OFFICE =
[0001000_2006042 4_084844_O].TRADE_OFFICE)) INNER JOIN
DPS_OFFICE_ADDR ESS ON DPS_OFFICE_ALIA S.OFFICE_ID =
DPS_OFFICE_ADDR ESS.OFFICE_ID
WHERE (((DPS_OFFICE_A LIAS.TRADE_FIRM )="1000") AND
(([0001000_2006042 4_084844_O].TRADE_FIRM) Is Null) AND
(([0001000_2006042 4_084844_O].TRADE_OFFICE) Is Null));

The "DPS_OFFICE_ALI AS" is the DB2 table. 0001000_2006042 4_084844_O is
the access table. This query returns records in the DPS_OFFICE_ALIA S
table that are not in the 0001000_2006042 4_084844_O table.

I create the MS Access databases in code so the ODBC connection
information to the DB2 tables is not in the database.

I see I have 2 choices;
1. Link the DB2 tables to the current MS Access database. How do I do
this in code?

2. Place the connection information to the DB2 tables in the SQL. How
do I do this in code?

Any help or observations will be greatly appreciated.

Jerry