By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Connect to DB2 server from SQL Server 2005

P: 60
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.
May 12 '09 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 2,878
Here's what google said How to create a SQL Server linked server to DB2

--- CK
May 13 '09 #2

P: 60
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?
May 14 '09 #3

P: 60
May 29 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.