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

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

P: n/a
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.

Sep 26 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.