Solved

Linked Server

Posted on 2013-02-04
3
263 Views
Last Modified: 2013-03-02
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,
0
Comment
Question by:AAWICT
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
deviprasadg earned 500 total points
ID: 38853871
You can find detailed steps here:
http://support.microsoft.com/kb/222937
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38854413
<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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38854435
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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question