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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| Thread Tools | |
| Display Modes | |
|
|