Linked Server

Dear Experts,

I am trying to import tables from the linked server to my local DB using Ms SQL server 2008 R2. My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.

Any advice?

Regards,
AAWICTAsked:
Who is Participating?
 
deviprasadgCommented:
You can find detailed steps here:
http://support.microsoft.com/kb/222937
0
 
Eugene ZCommented:
<My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.>

what sql server version\edition do you use?
what sql server permissions do you have?
0
 
Eugene ZCommented:
try to
exec sp_tables_ex yourlinkedservername

sp_tables_ex
Returns table information about the tables from the specified linked server.
---

2 things can be -- used DB2 driver and DB2 user permissions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.