Unix Technical Forum

Setting up a linked server in MS SQL using IBM OLE DB PRovider for DB2

This is a discussion on Setting up a linked server in MS SQL using IBM OLE DB PRovider for DB2 within the DB2 forums, part of the Database Server Software category; --> I am using DB2 UDB Application development client v8.2.5. I am trying to setup a linked server in MS ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:18 AM
sriharim@yahoo.com
 
Posts: n/a
Default Setting up a linked server in MS SQL using IBM OLE DB PRovider for DB2

I am using DB2 UDB Application development client v8.2.5. I am trying
to setup a linked server in MS SQL Enterprise Manager using the IBM OLE
DB Provider for DB2 to connect to databases on DB2 for z/OS v7 and v8.

The connection string I used is Provider=IBMDADB2;Data Source=xxxx
and location C:\Program Files\IBM\SQLLIB\BIN.

After creating the connection, when I click on the tables/views under
that linked server, I get the following error..

Error 7303: Could not initialize data source object of OLE DB Provider
'IBMDADB2'
OLE DB error trace[OLE/DB provider 'IBMDADB2' IDBInitialize::Initialize
returned 0x8004d01c]


Please help.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:00 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com