Connect to DB2 server from SQL Server 2005

I'm running SQL Server 2005 (fairly new to this application) and I'm looking to use this to connect a DB2 server, and also a MDB file (if possible).

My goal is to run queries out of DB2 that uses cursors (we have a trigger file that we need to parse) and save the results in a SQL Server table.

Can anyone point me in the direction of how I'd connect to DB2 from SQL Server? I can find plenty of examples of connect to DB2 or SQL from MS Access, but not the other way around.

re: Connect to DB2 server from SQL Server 2005

Here's what google said How to create a SQL Server linked server to DB2


--- CK

re: Connect to DB2 server from SQL Server 2005

I followed the steps outlined, however I've now run into two problems:

1) I cannot figure out how to reference the linked database (select * from LINKED.TABLE_NM doesn't seem to work)

2) I cannot modify the linked server settings, or remove the server (it gives me an out of memory error, which I know I'm not).

Any ideas on this?

re: Connect to DB2 server from SQL Server 2005

bump.......................